Insert into statement problem!

[qasmi]

I am getting a following error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

with the following insert into statement....

"INSERT INTO tbl (User_ID, Reffered_By, Communicated_by, Reference_Date, Applicant_Name, Subject, Target_Date, u_Date, Dept_ID, Status, Type_of_Work_ID, c_no) VALUES ("&request.form("txtUserID")&", '"&request.form("txtReferedBy")&"', '" &request.form("txtCommunicatedBy")& "', '" &request.form("txtReferenceDate")& "', '" &request.form("txtApplicant")& "', '" &request.form("txtSubject")& "', '" &request.form("txtTargetDate")& "', '" &request.form("txtDate")& "', " &request.form("txtDept")& ", '" &request.form("txtStatus")& "', " &request.form("txtWorkType")& ", '" &request.form("cno")& "')"

any ideas why it is giving me this error... User_ID, Dept_ID, Type_of_Work_ID are the only numeric fields rest are text fields..... any ideas.... thanks in advance!

 

[Cheech]

Look at your variables, depending on how your dates are declared in the database and on the page, but you may need "#" surrounding them.

Cheech

[Peace][Pipe]