What is my code missing? (Variables help)

[Guest_imported]

<%
productid=valid_sql(request.querystring(&quot;productid&quot)
set rsminlist=db.execute(&quot;select minorder from products where productid=&quot; & productid & &quot; order by name&quot

quantity = request.form(&quot;qty&quot
minorder = rsminlist(&quot;minorder&quot

if quantity < minorder then
'the quantity is less than minorder
else
'the quantity is not less than minorder
end if

%>

minorder is in the Access database as 100.
quantity is a form input. Any number I put in the form, say 50 returns that quantity is not less than minorder.
50 is less than 100 so why wont it work?

What am I missing please?!

-love,
cid

 

[foxbox]

Try:

if Cint(quantity) < Cint(minorder) then

...etc br
Gerard
(-:

Better a known bug then a new release.

 

[Guest_imported]

It worked!
Thank you soooooo much.
I still have a lot to learn with this stuff.

-cid