Is Not Equal To Nothing?

[BarryMVS]

Hi all,

I'm trying to put together an ASP check to make sure that a set of variables contain the correct data before proceeding.

I have three data variables, (v1, v2 and v3), and I want make sure that v1 and v2 contain data if v3 does.

I have tried the following:

if v1 or v2 = "" and v3 <> "" then

but this didn't work, (Type mismatch) so I tried:

If v1 or v2 = Null and v3 <> Null then

but this errored also.

The variables contain peoples names, but I can not get it to give me the result I'm after.

Any ideas most welcomed.

Thanks,

Barry

ICT Network Administrator
IT Services Manager

 

[ChrisHirst]

each variable has to be checked seperately

addition in red

if v1 [red] = ""[/red] or v2 = "" and v3 = ""

Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[BarryMVS]

Cheers Chris.

Solved the problem.

Can't believe I didn't think of it!


Barry

ICT Network Administrator
IT Services Manager

 

[Chopstik]

Just as an additional side thought, when checking for null, you should check to see if it is null, not = null. This is never true: Null = Null. Instead, it should read:

if isnull(v1) 'Since there actually is a built-in ASP function for this.

.

------------------------------------------------------------------------------------------------------------------------
"The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at or repair."
--Dou