Null in database

Results 1 to 4 of 4

Thread: Null in database

  1. #1
    Domain Guest

    Default Null in database

    In database field set to NULL, when I do a <BR>if rs("field")=null it gives false.<BR><BR>If i do<BR>if rs("field")="" it always gives false<BR>Basically whatever I try gives false results?

  2. #2
    wussy boy noodle Guest

    Default i like to use

    if len(trim(rs("whatever")))&#062;0 then.....

  3. #3
    Domain Guest

    Default RE: i like to use DIDNT WORK

    didn&#039;t work<BR>

  4. #4
    Join Date
    Dec 1969

    Default This should...

    ...<BR><BR> if len(Trim(oRS("colname") & "")) &#062; 0 then<BR><BR> the appending of the "" forces the column to be evaluated<BR> as a string.

Posting Permissions

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