Error converting data type varchar to numeric.

[aspnetuser]

I get the following error message when trying to check a check box that will update a sql field type INT.

Error converting data type varchar to numeric.


web form
hours check box


hours is set to numeric. chekc box is set to int.

it only fails when i try to check a check box and hit submit

it works if both types are set to int

but i need hours as a numeric.

any ideas on how to fix this?

 

[onpnt]

cInt where you insert it into the DB should fix it.

___________________________________________________________________

_{onpnt.com
SELECT * FROM programmers WHERE clue > 0
(0 row(s) affected) -->faq333-3811}

 

[aspnetuser]

sql = "update qryEnterHours set Hours = '" & hours & "' where Username = '" & Username & "' and PayDates = '" & PayDates & "'"
set rs = DbConn.Execute(sql)
set rs = nothing

he is where it fails? how do i fix it with cint?

 

[rodentcentre]

take off the single quotes

sql = "update qryEnterHours set Hours = " & hours & " where Username = '" & Username & "' and PayDates = '" & PayDates & "'"

 

[aspnetuser]

I took them off and get :
Incorrect syntax near the keyword 'where'.

 

[onpnt]

Try

Development practices when using SQL/Interfaces
faq333-4896

___________________________________________________________________

_{onpnt.com
SELECT * FROM programmers WHERE clue > 0
(0 row(s) affected) -->faq333-3811}

 

[aspnetuser]

onpnt

It was working fine until I changed the hours data type to numeric and the check box fields stayed int

is their anything else you could help me with?

 

[Genimuse]

The single quotes need to come out of the hours part, but stay in the username part. You use single quotes in SQL to denote strings: username is almost undoubtedly a string, while hours is not.

Also, you might try the asp.net forum, forum855 I believe.