Hi there

I'm getting an error message when I am using an 'if....then' statement. This is the error:

Microsoft VBScript compilation error '800a03f9'

Expected 'Then'

/service.asp, line 67

if isNull rsServices("Imagesml") or rsServices("Imagesml") = empty then

I don't know why it's asking me for a 'then' when I already have one.

Any help much appreciated.

Adam

isNull needs to have a parameter. you probably want:

if isNull(rsServices("Imagesml")) or IsNull(rsServices("Imagesml"))then

Yehuda

Hi there

But if I make both of them isNull, then it defeats the OR option where I ask if the field is empty?

thanks

Adam

if isNull rsServices("Imagesml") or rsServices("Imagesml") = empty then

Is that marked in RED a variable? If so what does it hold in it? If not What do you want to check there with?

CheerS!

_________________________
- Vijay G
Strive for Perfection

I am not sure what empty is supposed to be. Is Empty a variable? Is it ""? Is it IsEmpty (as in the variable has not been initialized)? Whatever it is empty appears not to be valid. What are you trying to do?

Yehuda

if isNull rsServices("Imagesml") or isEmpty(rsServices("Imagesml")) then

This should work.
Cheers!

_________________________
- Vijay G
Strive for Perfection