about query null value

Results 1 to 2 of 2

Thread: about query null value

  1. #1
    Join Date
    Dec 1969

    Default about query null value

    If I want to check if one of the item in recordset is empty, how do I do it?<BR><BR>I have tried:<BR>if rs("Name") = "" then<BR>Also tried:<BR>if len(trim(rs("Name")))&#060;1 then<BR>even<BR>if len(rs("Name"))&#060;1 then<BR><BR>None of them worked. Using len() with empty rs("name") does not even return a value 0. Is there anyway I can do this? <BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: about query null value

    Try isNull(rs("Name"))

Posting Permissions

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