Problem with empty RecordSet

[alexxx]

Hi!
I want to insert the value of a query into a text box, but the recordset might be empty. So I want that if this happens the text box keeps empty.
The code I have tried is the following:

<INPUT TYPE=&quot;TEXT&quot; NAME=&quot;codigo&quot; SIZE=40
<%if not (RS.EOF and RS.BOF) then%>
VALUE=<%=RS(&quot;codigo&quot%>>
<%end if%>

When RS is empty I get an error.
Somebody can tell me how to do this properly?
Thanks!

 

[FesterSXS]

just use:

If NOT rs.EOF Then
...
End If

if the recordset is empty then both EOF and BOF will be set so you only need to check one of them.

Tony

http://www.phoenix-paints.co.uk/portfolio