Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    165

    Unanswered: displaying html attributes for null fields

    i have a table which displays information from out database. some of the fields in the database are null...no problems there. howerver, when the information is displayed in the table, the border attributes for the fields with null values disappear. is there a way to keep the html attributes for field with null values b/c it really makes the table look bad. Thanks for any help. i'm also using classic ASP, not ASP .NET. thanks

  2. #2
    Join Date
    Jan 2005
    Posts
    165
    nevermind...i figured it out

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Also Nulls such as in variables can be a problem when trying to use them in comparisons. So I usually convert things like text fields from a database that could be Null to be "" instead of Null:

    MyVar = jpsvbNullToBlank(MyVar)

    Function jpsvbNullToBlank(pvarFld)
    ' Convert Null to blank.
    If IsNull(pvarFld) Then
    jpsvbNullToBlank = ""
    Else
    jpsvbNullToBlank = pvarFld
    End If
    End Function
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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