limberwulf
IS-IT--Management
I know my sql statement is in a big long line, but the error Im getting is unusual.
this is the error.
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/managers/computerproblem.asp, line 18
INSERT INTO troubleticket(Property_num,User_name,Issue_Month,Issue_Day,Issue_Year,Issue_type,Issue,Description) VALUES(" & "'" & Property_num & "','" & User_name & "','" & Issue_Month & "','" & Issue_Day & "','" & Issue_Year & "','" & Issue_type & "','" & Issue & "','" & Description & "'" & "
------------^
and this is my code. any ideas?
<%
response.buffer = "true"
Property_num=request.querystring("property"
User_name=request.querystring("computer_user"
Issue_Month=request.querystring("month"
Issue_Day=request.querystring("Day"
Issue_Year=request.querystring("Year"
Issue_type=request.querystring("issue_type"
Issue=request.querystring("specific_Issue"
Description=request.querystring("description"
sDBName = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=f:\0ED\artcraftcos.com\files\databases\computer_trouble.mdb;"
Set objDB = Server.CreateObject("ADODB.Connection"
objDB.open
INSERT INTO troubleticket(Property_num,User_name,Issue_Month,Issue_Day,Issue_Year,Issue_type,Issue,Description) VALUES(" & "'" & Property_num & "','" & User_name & "','" & Issue_Month & "','" & Issue_Day & "','" & Issue_Year & "','" & Issue_type & "','" & Issue & "','" & Description & "'" & "
objDB.Close
Set objDB = Nothing
response.redirect "troubleticketconfirmation.asp"
%>