I noticed that when I use a <> (Not Equal) in my if then statements, then it runs successfully. However, if I use an = , then it fails.. Can you use = and im just coding wrong? or should you always use <>.

For example
<% IF rsRecordset.field.value=0 then bla bla bla

This Fails

But if I use
<% IF rsRecordset.field.value<>1 then bla bla bla

Then this works!!!

Any ideas?

Edited by - lkcastro on 14 Sep 2006 02:33:57

Lou,

Most probably the value is just not equal to 0, but e.g. 'No' or something...
Check the exact value in your database and use this in your IF...THEN...
Should work.
Don't forget to use 'No' (quotes !) if your field is not numeric.

Hope this helps,

Wim

Wim Conix
www.image-belle.com