Empty recordset

Results 1 to 2 of 2

Thread: Empty recordset

  1. #1
    Join Date
    Dec 1969

    Default Empty recordset

    I have a dynamic recordset that sometimes doesn&#039;t return any results. How do I check to see if the recordset is empty before more code is processed?<BR><BR>Here is the error I get when its empty:<BR><BR>ADODB.Field error &#039;800a0bcd&#039; <BR><BR>Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. <BR><BR>/SPECSUB/ss/test.asp, line 32 <BR><BR><BR>Thanks,<BR>Lane

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Empty recordset

    if RecordsetName.eof then<BR>&#039;empty<BR>else<BR>&#039;has some crap<BR>end if<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts