|
 |
asp_web_howto thread: RE: FW: urgent....I am getting crazy
Message #1 by "Drew, Ron" <RDrew@B...> on Wed, 12 Jun 2002 17:29:54 -0400
|
|
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")=3D"" 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=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20
Message #2 by william.sze@s... on Wed, 12 Jun 2002 17:09:29 -0400
|
|
Try Trim(rsprod("image"))=""
"Eric Van
Camp" To: "ASP Web HowTo" <asp_web_howto@p...>
<eric@a... cc:
be> Subject: [asp_web_howto] FW: urgent....I am getting crazy
06/12/02 05:07
PM
Please respond
to "ASP Web
HowTo"
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
Message #3 by "Aaron Fleming" <aaronf@w...> on Wed, 12 Jun 2002 17:13:12 -0400
|
|
Try this instead:
If isNull(RS) then 'where RS is your recordset
response.write = "something"
else
response.write = "something else"
End if
Aaron Fleming
WebPartz INC
aaronf@w...
-----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
Message #4 by "Eric Van Camp" <eric@a...> on Wed, 12 Jun 2002 23:07:01 +0200
|
|
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
|
|
|
View Cart
