|
sentinel -> Passing Numeric into Tinyint field (3/28/2008 15:16:46)
|
hey all....
I am using the following code to try to pass a numeric value into a TINYINT field in Mysql 5.
"INSERT INTO ot (ot1,ot2,ot3,UserID,DateEntered,OTHours1,OTHours2,OTHours3) VALUES ('" & request.form("ot1") & "','" & request.form("ot2") & "','" & request.form("ot3") & "', '" & user & "',curdate(),'" & request.form("OTHours1") & "','" & request.form("OTHours2") & "','" & request.form("OTHours3") & "')"
I receive this error:
Database Results Error
Description: [MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-community-nt]Incorrect integer value: '' for column 'OTHours1' at row 1
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers
Am i trying to insert the OTHours1 using the wrong format or something? I can add values manually from command line but not using the SQL code.
Thanks
|
|
|
|
