error on sql insert

[ashwika42]

hi
I am getting an error :
on execute statement ! :

error is :

Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near ','.

--------------------------------
this is the statement :

sql = "insert into requirements (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

any help would be much appreciated .


Thanks

[MikeTheBike]

Hi

On initial inpection I think you need to change this
, GetDate(), GetDate(),
to this
," & GetDate() & ", " & GetDate() & ",

and this
, GetDateTime(),
to
," & GetDateTime() & ",

Or possibly even this
,#" & Format(GetDate( ),"mm/dd/yyyy") & "#, #" & Format(GetDate( ),"mm/dd/yyyy") & "#,
and
,#" & Format(GetDateT ime(),"mm/dd/yyyy") & "#,

??

HTH

[ashwika42]

sorry my mistake I have too many fields on the insert : 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 & "') "     

I am still getting the error - could it be from 
DbObj.Execute(SQL)
 on error resume next

I will take your advise ... and see ....

[ashwika42]

I tried replacing with " & GetDate() &" etc but still sam error

[MikeTheBike]

You have nit tried my suggestions?

[ashwika42]

I tried that too - I got the error
Type mismatch: 'GetDate'

[MikeTheBike]

What does GetDate() return?

is it a date or a string?

I suggest you either insert msgbox SQL or debug.print sql before DbObj.Execute(S QL) and examine the resulting string and post it here if you use the debug.print optuon (the string will appear in the immediate window - Ctrl+G).

[Rabbit]

Please use code tags when posting code or formatted data.

You have extra parentheses at the end of line 3 and the beginning of line 4.