DECLARE CURSOR … FOR UPDATE
Just a quick post to basically document somewhere the problem I was getting and the solution I found.Take the following cursor declaration: DECLARE cur_Columns CURSOR LOCAL FOR SELECT DISTINCT person_id FROM Company_People WHERE company_id = @company_id FOR UPDATE OF person_id There is no obvious reason to me why this should not work, but attempting to [...]
XSLT Optimisation
As far as I remember, the first time I had to use XSLT was nearly 2 years ago, where we were required to use XSLT to produce HTML/XHTML reports from XML data returned and modified by our client. Since I was new to the language (also new to XQuery as you can imagine) I used [...]
Visual Studio 2008 Editions Comparison
When it comes to deciding which Visual Studio version you should use (aside from the issue of which MSDN subscription you purchased or how much money you have to throw at Visual Studio) there are some very big differences between versions that you might find yourself leaning towards more or less than others. I have [...]
Request.Url using SSL
A lesson learned the hard way: browsers do not post referring URL information to a HTTPS connection, and it looks like there may some more spanners in the works preventing Request.URL from providing the correct URL. This makes sense in the fact that the headers aren’t necessarily secure – Firefox for example had a long [...]
