Hi
I am getting an error when the SQL script returns a null recordset query. The SQl statement is fine and no reocords are expected for this particular client that I am querying. How can I handle the error to run some other code against it...I have
if (objTaxData(0)) <> "" then
call display_tax
else
Response.Write "<br><br><br><center><h1><font color = red size = 7>"
Response.Write "There is no data for this Client.</font></center><br>"
end if
yet I keep getting this error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record
What is the best way of handling this case?
thanks in advance
Bastien
I am getting an error when the SQL script returns a null recordset query. The SQl statement is fine and no reocords are expected for this particular client that I am querying. How can I handle the error to run some other code against it...I have
if (objTaxData(0)) <> "" then
call display_tax
else
Response.Write "<br><br><br><center><h1><font color = red size = 7>"
Response.Write "There is no data for this Client.</font></center><br>"
end if
yet I keep getting this error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record
What is the best way of handling this case?
thanks in advance
Bastien