[thelist] ASP Question: If there is nothing to pull from the database...

[Michele Foster]

Hey Josh,

Is there an advantage to using your approach as opposed to the one Paul
suggested, which was

"If objRS.Eof AND objRS.Bof Then"

?

Personally, I use Paul's approach .. but I'm always eager to learn
new/better ways to doing things if they exist.

What do others do/prefer ?


Thanks,

Michele
(p.s.  for some odd reason your message was held in the queue awaiting
approval .. not sure why that is though .. mime type perhaps?)


----- Original Message -----
From: "josh" <evolt at efeingold.com>

| It depends on the query you use to access the data which depends on the
| structure of the database.
|
| If the recordset is returned with multiple columns, you would want to test
| for a null value in the recordset of that column.  Use the isnull
function.
|
| e.g.
|
| if isnull(rs("test")) then
| response.write("Be the first to add a comment...")
| end if