Record Exists?

Results 1 to 2 of 2

Thread: Record Exists?

  1. #1
    Join Date
    Dec 1969

    Default Record Exists?

    whats the simplest way to find out of a record is null?<BR>was trying this, but doesn&#039;t work.<BR>If rs("somerow")= null Then<BR><BR>any ideas?<BR>thanks in advance for your time!

  2. #2
    Join Date
    Dec 1969

    Default Hmmm

    If records are returned but the column is null, this is probably the easiest:<BR><BR> if rs("columnname") & "" = "" then<BR> &#039; is empty<BR> end if<BR><BR>If you are talking about whether there records or not<BR>you should check the end of file marker.<BR><BR> if not rs.EOF then<BR> &#039; there are records<BR> end if

Posting Permissions

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