select insert error - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

select insert error

dylan42dylan42 Posts: 2Member
edited October 2013 in Active Server Pages

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

Tagged:

Comments

  • dylan42dylan42 Posts: 2Member

    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 & "') "

Sign In or Register to comment.