Posted by Adam Buenz
Ugh! Finally I got my new hosting space so that I don’t get anymore MySQL errors and have to do constant table repair commands, which would often fail with a datawrite operations because of the temporary allocation required to run them. Yea!
So I went from this tragedy
To being in the green (or blue […]
Posted by Adam Buenz
Today I went to the last lecture that concluded my foundational MBA course at USC (actually I am still in the lecture hall while I am writing this). The title of the lecture sounded intimidating: The Degradation of Empirical Software Development Management Techniques. Yikes. However extensive and unapproachable the title made […]
Posted by Adam Buenz
A friend just asked me the way to cast a SPList To a SPDocumentLibrary so that he could access the document library specific attributes for document library objects. This is one way of doing it:
Select For Unformatted Code
C#:
public static SPWeb GetWeb(string url)
{
using (SPSite site = new SPSite(url))
{
using (SPWeb web = site.OpenWeb())
{
return web;
}
}
}
public static SPDocumentLibrary CastDocumentLibrary(string [...]
Posted by Adam Buenz
So, today one of my friends asked me if I knew how to return the names of all the fields in a table using a stored procedure so that he could build the names into a generic string collection. This is how you do it:
Select For Unformatted Code
SQL:
CREATE PROCEDURE [dbo].[GetColumnNames] @tableName VARCHAR(50)
AS
SELECT name
FROM syscolumns
WHERE id [...]
Posted by Adam Buenz
I was at a small lecture at USC yesterday for a foundational MBA course where the subject of the talk was varying management approaches across assorted industries when dealing with common software management. It was a brilliant discussion, very well thought out by Professor Ashby of the Economics Department. I really enjoyed the latter section [...]
Posted by Adam Buenz
I have. I know I barely pay anything for it, but the service is just terrible. I couldn't run datafile bound mySQL commands because of space concerns (because it issues temporary space allocation), and even when I email, call, and yell really loud that I want to give them more money to extend my package, [...]