Math Problem

[disord3r]

I'm probably just blind, but, here's the setup.

Paging through a recordset. Need to print only the records where the value of "total" is greater than the value of "notices". "total" comes from the recordset, and "notices" is from an HTML form. As such, the value of "total" will vary, while the value of "notices" will stay the same. Here's the code, pretty straight-forward:

while not RS.EOF
total = rs("total&quot
Response.Write total & ", " & notices

if total > notices then
Response.Write &quot; yep<BR>&quot;
else
Response.Write &quot; nope<BR>&quot;
end if

RS.MoveNext
wend

Here's an excerpt of the output:

...
1, 6 nope
1, 6 nope
1, 6 nope
1, 6 nope
7, 6 nope
...

&quot;7, 6 nope&quot;??? Last I checked, 7 was greater than 6.

Any advice is appreciated.

 

[JuanitaC]

You might want to ensure that total and notices are of the same type when you compare them. Convert them using CInt or CDbl or CLng, depending on the type of data. So, assuming that they should both be int type, try:

if CInt(total) > CInt(notices) then
Response.Write &quot; yep<BR>&quot;
else
Response.Write &quot; nope<BR>&quot;
end if