comparing field data from previous field in loop with null values

[abbylee26]

Im comparing values in a field while doing a loop
if sAct<>myData(5, i) then
At the end of the loop I make the value of sAct equal the current
myData

This will work when comparing other fields withing my recordset (so I
know the statement works) but it will not work for the field I want to
compare. The only difference with this field is that it has null
values. Could this be the problem? if so, how do I deal with nulls?

[abbylee26]

I should say my code works but just completely ignors null values. I
need it to treat nulls like anything else. My code will catch when it
changes from A11 to B17...I also need for it to catch a change from G38
to null

sAct<>myData(5, i)

What do I need to change?

[Bob Barrows [MVP]]

ab*******@hotma il.com wrote:

Im comparing values in a field while doing a loop
if sAct<>myData(5, i) then
At the end of the loop I make the value of sAct equal the current
myData

This will work when comparing other fields withing my recordset (so I
know the statement works) but it will not work for the field I want to
compare. The only difference with this field is that it has null
values. Could this be the problem? if so, how do I deal with nulls?

if sAct<>myData(5, i) & "" then
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[abbylee26]

if sAct<>myData(5, i) & "" then

This doesn't seem to work...even so the statement wouldn't really work
here anyway.

If for example sAct is null and myData(5,i) has a value, this statement
would not pick up on the change. I need this trigger to go off if there
is any change between the two objects.

[Bob Barrows [MVP]]

ab*******@hotma il.com wrote:

if sAct<>myData(5, i) & "" then

This doesn't seem to work...even so the statement wouldn't really work
here anyway.
Then, I'm sorry, but you're going to have to do a better job of describing
what "doesn't work" means. What I posted was a stab based on what I guessed
you meant.
If for example sAct is null and myData(5,i) has a value, this

Oh come on!

if sAct & "" <>myData(5,i) & "" then


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Evertjan.]

wrote on 14 feb 2006 in microsoft.publi c.inetserver.as p.general:

if sAct<>myData(5, i) & "" then

This doesn't seem to work...even so the statement wouldn't really work
here anyway.

If for example sAct is null and myData(5,i) has a value, this statement
would not pick up on the change. I need this trigger to go off if there
is any change between the two objects.

if (sAct & "") <> (myData(5,i) & "") then

[This will see a null and an emplty string as the same.]

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[abbylee26]

Thank you everyone...and thank you Evertjan