Archive for April, 2008

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, [...]