Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    160

    Unanswered: How to avoid null datto display

    Hi! I am new to asp

    I have an access data base and I want to dispaly only fields in data base table that have data. I don't want to display null data.Can any one help me.

    Thanks!
    Vad

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    Just have an if statement around the section that displays the data

    i.e.
    Code:
    if x.field(1)<>"" then
     response.write(x.field(1))
    end if

  3. #3
    Join Date
    Aug 2003
    Posts
    160

    how to avoid null data to display

    Thank U

    But here the problem is I want a table to display in the following format.


    -------
    Stock# l l GM857 ll Serial# ll 846128764 ll Trucktype ll general
    Mileage l l 34000 ll Color ll blue ll Cruise ll no

    In this case How is it possible.

    I wrote the statement u told me,it is displaying nothing but it is showing empty space.I don't want that empty space also.

    Thank U.
    Vad

Posting Permissions

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