empty field

Results 1 to 2 of 2

Thread: empty field

  1. #1
    davy Guest

    Default empty field

    for some reason, i cant figure out how to check to see if a field has nothing in it. neither of these two examples work:<BR><BR>strsql="SELECT * FROM " & table & " WHERE field=&#039&#039"<BR><BR>or when i do a full query, this wont work either:<BR><BR>if objrs("name") = "" then.....<BR><BR>thanks in advance.<BR><BR>best,<BR><BR>

  2. #2
    Leungas Guest

    Default RE: empty field

    Sol 1: select * from Table where Field is null<BR>Sol 2 ( in ASP ): if IsNull(Variable) then &#039routine

Posting Permissions

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