conn.execute(sql) when failed

[j2ibeo]

Hi,
I was wondering about this statement

Rs=conn.execute("Select * from table where id=232")

what is the result of Rs if id 232 is not found?
And how do I catch this exception like :
If not Rs then...?

thanks

[jhardman]

Hi,
I was wondering about this statement

Rs=conn.execute("Select * from table where id=232")

what is the result of Rs if id 232 is not found?
And how do I catch this exception like :
If not Rs then...?

thanks

The recordset will show EOF (end of file) as if you were looping thru the recordset and got to the end. To handle, you can say:

if rs.eof then
...
end if

or like this...

if NOT rs.eof then
   'perform all the code you want
else
   response.write "Sorry, no records were found"
end if

Let me nkow if this helps.

Jared