What am I missing?

[mendhak]

Pretty strightforward...

sqlstaffprofile = "SELECT * FROM staff WHERE staffid = " & staffid & ";"

objrs.Open sqlstaffprofile,objconn

if not objrs.BOF or objrs.EOF then



%>


<table width="462">
        <tr>
'SNIP SNIP SNIP

        </tr>
      </table>

<P>&nbsp;</P>

<%
else
Response.Write "No Records Found for that Staff ID"
end if

end if
%>

Instead of my message, I get

ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.

?

[blackeyed]

i guess you are not getting any record for this condition. so do one thing put the condition in the brackets or simply replace your code with this code. You have just missed a thorn in the sight.


if not (objrs.BOF or objrs.EOF) then

[mendhak]

Oh man.. sometimes I miss the smallest things. I need coffee..

Thanks.