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

Thank you all for your input on "best coding" I will implement the ones I feel best fit my style. But for the problem at hand, does anyone know what would be causing it? I can log into the SQL DB and veriy there is no blank entries.

Comment on Re: Pulling a blank SQL row, but there are no blank rows.

Replies are listed 'Best First'.
Re^2: Pulling a blank SQL row, but there are no blank rows. by Your Mother (Archbishop) on Jun 14, 2009 at 17:15 UTC
It occurred to me that if you have a quote which starts something like `<The best games require...` that maybe the HTML is burying it because of broken tags. I didn't think it was likely enough to mention though. The HTML escaping will expose/fix it if it's the case. I think it's more likely you do have empty/squirrelly data and you should make sure to do a totally braindead check like- `select Quote from dbo.GameQuotes` -and eyeball all of them.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: Pulling a blank SQL row, but there are no blank rows.
by Your Mother (Archbishop) on Jun 14, 2009 at 17:15 UTC

It occurred to me that if you have a quote which starts something like <The best games require... that maybe the HTML is burying it because of broken tags. I didn't think it was likely enough to mention though. The HTML escaping will expose/fix it if it's the case. I think it's more likely you do have empty/squirrelly data and you should make sure to do a totally braindead check like-

select Quote from dbo.GameQuotes

-and eyeball all of them.

[reply]
[d/l]
[select]