form field to convert to decimal 1

[TRACEYMARYLAND]

hi i have a form qty on hand
<%if request("QtyOnHand") = "" then
QtyOnHand = 0
else%>
<% QtyOnHand = CDBL(QtyOnHand)%>
<%response.write "on hand" & QtyOnHand
end if

When i put in value of 5...the value im getting is 0
i thought CDBL would give me 5

so if they put in 17.28 it going to pass this to sql
strSQL = "sp_Web_Window_PartId '" & request("PartId") & "', '" & request("Description") & "', '" & request("StockUm") & "', '" & request("Fab") & "', '" & request("Pur") & "', '" & QtyOnHand & "', '" & request("MfgName") & "', '" & request("MfgPartId") & "', '" & request("ProductCode") & "'"

sql
stored procedure
@QTY_ON_HAND decimal(14,4),

 

[mwolf00]

<%if request("QtyOnHand") = "" then
QtyOnHand = 0
else%>
<% QtyOnHand = CDBL(request("QtyOnHand") )%>
<%response.write "on hand" & QtyOnHand
end if

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[TRACEYMARYLAND]

Gosh silly me .....was too close to see the error

Thanks