IF RS FIELD = ""

Results 1 to 3 of 3

Thread: IF RS FIELD = ""

  1. #1
    Join Date
    Dec 1969
    Posts
    27

    Default IF RS FIELD = ""

    I am trying to write an IF THEN Statment...If rs("field")="" Then<BR>but that doesnt work for an rs field..does anyone know what it should be...If rs.eof works fine...but thats for the whole file...HELP!

  2. #2
    Jason Buck Guest

    Default RE: IF RS FIELD =

    This link should help you<BR><BR>http://msdn.microsoft.com/scripting/vbscript/doc/vsfctIsEmpty.htm<BR><BR>Try this:<BR><BR>If IsEmpty(rs("field")) Then<BR>do something<BR>Else<BR>do something else<BR>End if

  3. #3
    Join Date
    Dec 1969
    Posts
    27

    Default RE: IF RS FIELD =

    Thankyou, im off to try it.

Posting Permissions

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