Hopefully there are some ASP experts put there who can help me. I am trying to write an SQL insert statement to populate an access database from an HTML form. When I submit the form, I am getting page cannot be displayed with the following error message:
Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/asset/add_to_database.asp, line 32
" method & "', '" & description & "', '" & reason & "', '" & details & "')"
Here is my code. If anyone can tell me what I'm doing wrong it would be appreciated.
sSQL = "INSERT into assets (employee, date, manufacturer, model, department, serial, method, " & _
" description, reason, details) values ('" & employee & "', '" & date & "', '" & _
" manufacturer & "', '" & model & "', '" & department & "', '" & serial & "', '" & _
" method & "', '" & description & "', '" & reason & "', '" & details & "')"
ASKED:
Aug 20, 2008 6:08 PM GMT
UPDATED:
August 20, 2008 7:44:25 PM GMT