thaks guys...it worked all fine,
saved from becoming nuts!


-----Original Message-----
From: Drew, Ron [mailto:RDrew@B...]
Sent: June 12, 2002 23:30
To: ASP Web HowTo
Subject: [asp_web_howto] RE: FW: urgent....I am getting crazy


This will check the field, if it's not null, it displays it on the page.

If not IsNull(rsprod("image")) then Response.write rsprod("image")

-----Original Message-----
From: Eric Van Camp [mailto:eric@a...]
Sent: Wednesday, June 12, 2002 5:07 PM
To: ASP Web HowTo
Subject: [asp_web_howto] FW: urgent....I am getting crazy


i just want ot test wether a field is empty..
i tried this
if rsprod("image")="" then
	response.write "nothing"
	else
	response.write "something"
	end if
the connection with the database is ok, the recordset select the correct
product out of the database, if i look into access..the field is
empty..so normally this code should result in "nothing"...but it always
results in "something" am i really such a dumb person???what am i doing
wrong then??? image is a text field in the access database...and I AM
SURE nothing is saved into the field! please help i am getting MAD!!!!!

Eric




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20