Re^2: Pulling a blank SQL row, but there are no blank rows.

And I find the order by clause a bit strange: Why do you add backets to the newid - is a SQL-server speciality? That is just the way the SQL command is used.
And by the way: Why do you not use the SQL in $Statment but rather repeat it again? Old line of code form a test I was doing, thank for poiting it out I have removed it.
And is there anything wrong in using lower-case variable names and normal quotation marks just like everyone else does?My coding style is to make the first letter of all words in a varible uper-case, just an old habbit. Not sure what you mean by "normal quotation marks"
Probably not helpful but you could add a check to verify that the fetching does not fail (check @Quote for defined-ness).I could add a check to see if the array gets filled or not but what would I do if it did not? The point of this code is to grab a random quote from the DB and display it so I need to figure out why a blank quote is being grabed.

Comment on Re^2: Pulling a blank SQL row, but there are no blank rows. Select or Download Code

Replies are listed 'Best First'.
Re^3: Pulling a blank SQL row, but there are no blank rows. by morgon (Priest) on Jun 15, 2009 at 22:58 UTC
Just for curiosity: Is there any difference (in SQL server) between `select top 1 Quote, CharacterName, GameTitle from dbo.GameQuotes order + by newid()` [download] and `select top 1 Quote, CharacterName, GameTitle from dbo.GameQuotes order + by newid` [download] i.e. without the parentheses at the end of newid?	[reply] [d/l] [select]