if condition (simple but mind blowing)

BurhanKhan · October 22nd, 2004, 02:23 PM

Hi:
i have database text field named "value1", and this field is empty.

now i fetch it and store it in variable like:
value1 = objCat.Fields("value1")

now i check the condition, if value1 is empty then show "empty message" other wise show "not empty message". Like:

if value1 = "" then
   response.write "empty"
else
   response.write "not empty"
end if

Simple :) but result is that, it always shows "not empty". If i put some values in value1 in database, then be no effect. it is shown "not empty"

Then i change my code like this:
if value1 <> "" then
   response.write "not empty"
else
   response.write "empty"
end if

now it is working correctly :(

i did not understand what is the problem with first code.
Can any one see any problem?

Burhan

rajanikrishna · October 22nd, 2004, 07:35 PM

Hi Burhan,

  Check the first code with isnull function.

if isnull(value1) then
   response.write "No value"
else
   response.write value1
end if

---------
Rajani

happygv · October 24th, 2004, 08:22 AM

In addition to that you can also check that this way.

Code:

if len(trim(value1)) = 0 then
   response.write "empty"
 else
   response.write "Not empty"
 end if

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

kiwibey · November 23rd, 2004, 12:16 AM

actually i also always facing this problem....
finally i know hot to solve it yet....
haha..
thank you all of you...

bey

grstad · June 10th, 2005, 05:35 AM

is the db field set to be a number or text?