Dumb vbscript question

Help ME!

[Krapulator]

Hi,

I have a problem. The following script returns the value "2" regardless of the values of the variables.
Why O Why?

number_nights = (rates.Fields.Item("sNumberNights").Value)
day_diff = DateDiff("d", arrival, depart)

if (Cstr(number_nights)) < (Cstr(date_diff)) then
action = 1
elseif (Cstr(number_nights)) > (Cstr(date_diff)) then
action = 2
else
action = 3
end if
response.write action

[korkus2000]

Try CInt instead of CStr. I am guessing that the < and > values of your strings are coming up with option 2.

[Krapulator]

Nope, still get 2 every time with CInt

[oilman]

shouldn't you be useing day_diff in the comparison expressions instead of date_diff?

[Krapulator]

day_diff is just the name I've given the variable. Its value comes from the date_diff function at the top. However I have tried the same script without the variables, just dropping the date_diff function and recordset varible straoght into the comparison, but the result is still 2 doing it this way

[jatar_k]

oil was referring to this

day_diff = DateDiff("d", arrival, depart)

if (Cstr(number_nights)) < (Cstr(date_diff)) then

they don't match, if that is what you are trying to compare

[oilman]

right - I just thot maybe that was the variable you were wanting to compare and just put the wrong name in - I do it all the time. Just a thot :)

edit: what jatar said :)

[Krapulator]

Bloody Hell.

(Bangs head against wall - kicks self in arse - mutters profanities that would make a biker blush).

Im a bloody idiot.

It was right in front of my face.

Thanks guys - you just made my christmas card list!

[shady]

It may be a good idea (assuming it is available in vbscript) to use "option explicit" - that way the scripts will fall over with an error rather than treating undefined variables as zero.

Makes "finger trouble" stand out instead of giving you sleepless nights!