Avoiding fields that are empty 1

[timcadieux]

I've noticed that certain fields in my DB are empty, i want to avoid referring to them if they actually contain no text.

In this case, neither

rs(article)>1

or

ISNULL(rs(article))

Will work, other than changing the way the info is input into the db, how can i avoid this with existing information?

 

[DotNetGnat]

if rs(article)="" then

-DNG

 

[DotNetGnat]

i mean other way round :

if rs("article")<>"" then

or 

if len(rs("article")>0 then

-DNG

 

[timcadieux]

I tried both of those before posting, when i did a response.write Len(article), it gave me 36 but when i looked in the DB, the field was empty?

 

[DotNetGnat]

how about this:

if trim(rs("article"))<>"" then

or

if trim(len(rs("article"))>0 then

-DNG

 

[timcadieux]

I'll try those, thx!

 

[DotNetGnat]

i think the problem is that some of your data was deleted manually and spaces are still left out...and thats the reason you were getting a count of 36 and still you see the database field as empty...

you can also do...

if rs("article")<>"" OR ISNULL(rs("article")) then

-DNG

 

[timcadieux]

isn't trhat contradictory, shouldn't it be
if rs("article")<>"" OR NOT ISNULL(rs("article")) ??

 

[DotNetGnat]

i meant to say:

if rs("article")="" OR ISNULL(rs("article")) then

thanks for the correction, though...trim() function should work fine for you...

-DNG

 

[timcadieux]

That worked, kool!!!

Thx for your help!!

 

[DotNetGnat]

no problem...glad to be of help...

-DNG