Re: No result at all (expected 0)

2005-06-16 Thread SGreen
And exactly what you expect "nothing" to look like? If "nothing" (no rows) is the correct response to your query, how would you like it formatted? Without knowing exactly how you are executing this query, it's impossible to know how to tell you how to detect an empty result set (assuming you a

RE: No result at all (expected 0)

2005-06-16 Thread Jay Blanchard
[snip] I have a little question. I have two tables which are used for saving private messages. If a user has NO messages, the result doesn't return _anything_. I expected to get "0 results" but this really confuses me. [/snip] If there is no data you should get an 'Empty set (0.00)' message or s

RE: No result at all (expected 0)

2005-06-16 Thread J.R. Bullington
You got exactly what the db found. An "Empty Set". You wouldn't get '0' results because there aren't '0', it's EMPTY. It's not NULL either since NULL is a form of non-existence. Why were you expecting '0'? J.R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: