i have a select statement whch is gettin an error on the execute of this statement - what could this mean ??
sql = "insert into abacus.itc_alerts (message, priority,server, ip, usr, creationTime, modificationTime, Title, deleted, " &_
"EventName, PriorityComm, Service, CallRef, Description, DateTimeIncident, BusinessImpact, NextSteps) values " &_
"('" & strData & "', " & priority & ", '" & ip & "', '" & usr & "', GetDate(), GetDate(),'" & title & "','" & eventName & "') " &_
"('" & priorityComm & "','" & service & "','" & callRef & "','" & description & "', GetDateTime(),'" & businessImpact & "','" & nextSteps & "') "
DbObj.Execute(SQL)
on error resume next_
error is : Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near ','. line 82 which is the execute statemnt
Any help would be much appreciated
It looks like you're new here. If you want to get involved, click one of these buttons!
Comments
sorry it should be :
sql = "insert into requirements (message, priority, ip, usr, creationTime, modificationTime, Title, " &_
"EventName, PriorityComm, Service, CallRef, Description, DateTimeIncident, BusinessImpact, NextSteps) values " &_
"('" & strData & "', " & priority & ",'" & ip & "', '" & usr & "', GetDate(), GetDate(),'" & title & "','" & eventName & "',)" &_
"('" & priorityComm & "','" & service & "','" & callRef & "','" & description & "', GetDateTime(),'" & businessImpact & "','" & nextSteps & "') "