value of blank field

Results 1 to 3 of 3

Thread: value of blank field

  1. #1
    techky Guest

    Default value of blank field

    this is a very simple question<BR><BR>i am trying to show a table of values from a database.<BR>If the field in the database is blank, then the cell in that table is "none".<BR><BR>this is my code:<BR> if rs_List("Designation") = "" then<BR> response.write("None")<BR> else<BR> response.write(rs_List("Designation") <BR> end if<BR><BR>but is not working and i wonder if the blank value is something else.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: value of blank field

    If the db gets updated sometimes the field, even though there doesn&#039t seem to be anything in it can be greater than nothing.<BR><BR>You might try soemthing like this:<BR><BR>If len (Designation) &#062; 0 then<BR>response.write("None")<BR>else<BR>response .write(rs_List("Designation") <BR>end if<BR><BR>Hope that helps

  3. #3
    Tecky Guest

    Default RE: value of blank field

    thanx a lot ^ ^

Posting Permissions

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