Microsoft SQL Native Client error '80040e14'

[anon1971]

I am getting this error adn I just can't figure out why.


'The Error

Microsoft SQL Native Client error '80040e14'

Incorrect syntax near the keyword 'User'.

/apps/cs/login/edit/update.asp, line 226



'The Code the error is coming from.

ProjectID=session("ID")
Subject="Account Update"
Note=Trim(Request.Form("office_comment"))
NoteDate=Now
Complete="-1"
Followup=Date
User="WEB"


sql = "INSERT INTO NotesD (ProjectID, Subject, Note, NoteDate, Complete, Followup, User)" & _
"VALUES ('"& ProjectID & "','" & Subject & "','" & Note & "','" & NoteDate & "','" & Complete & "','" & Followup & "','" & User & "')"
conn.execute sql, , 129

 

[gmmastros]

user is a reserved word. You should try to avoid using a reserved word for your column names, but when you can't avoid it, you can use square brackets to get the query to work. Like this...

sql = "INSERT INTO NotesD (ProjectID, Subject, Note, NoteDate, Complete, Followup, [!][[/!]User[!]][/!])" & _

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[anon1971]

Got it and the funny thin gis the name in the sql database had square bracets lol