How to avoid null datto display

vad · #1 (**permalink**) 09-26-03, 14:10

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!

rhs98 · #2 (**permalink**) 09-26-03, 14:19

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

vad · #3 (**permalink**) 09-26-03, 15:07

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech