How can I fix this Syntax error in INSERT INTO statement.

[RFH Reseller: HostCan]

Hi,
I need urgent help about ASP INSERT INTO statement.

I have this code:


'store the desired SQL statement into a variable
'add the link as inactive 'N' as it needs admin approval
sSQL="INSERT INTO tbllinks (Name,URL,Description,Date_Added,Active,Category," & _
"Contact_Name,Contact_Email,Keywords,Contact_Tel,C ontact_Fax,user,pass) VALUES ('" & sName & "', '" & sURL & "','" & sDescription & "'," & _
"'" & dDateAdded & "','N','" & iCategoryID & "','" & sContactName & "'," & _
"'" & sContactEmail & "','" & sKeywords & "','" & sTel & "','" & sFax & "','" & sUser & "','" & sPass & "')"

oConnection.execute(sSQL)





when I submit form I recieve this error

Microsoft JET Database Engineerror '80040e14'
Syntax error in INSERT INTO statement. /Aadd_link_process.asp, line 100



Line 100 is this

oConnection.execute(sSQL)



I've changed line 100 to

response.write(sSQL)


and I got this:

INSERT INTO tbllinks (Name,URL,Description,Date_Added,Active,Category,C ontact_Name,Contact_Email,Keywords,Contact_Tel,Con tact_Fax,user,pass) VALUES ('ALI', 'http://www.mydomain.com','description','14/02/2008 17:31:23','N','21','John','flo697@hotmail.com','ad fvadfva','2164442233','2164442233','0123456789','2 2421395')



Seem like there is no error

So where is my mistake?

[RFH Reseller: HostCan]

I just found and fixed it...

Something I learnt now. there are reserved words for MsAccess user was one of them, when I changed colum name to Main_User it's been fixed.

[RFH Reseller: askjim]

In SQL Server you can put the column name in [] brackets to get round reserved key words.

[RFH Reseller: HostCan]

In SQL Server you can put the column name in [] brackets to get round reserved key words.

Thanks for the tip.
Like this?

'store the desired SQL statement into a variable
'add the link as inactive 'N' as it needs admin approval
sSQL="INSERT INTO tbllinks ([Name],URL],[Description],[Date_Added],[Active],[Category]," & _
"[Contact_Name],[Contact_Email],[Keywords],[Contact_Tel],[C ontact_Fax],[user],[pass]) VALUES ('" & sName & "', '" & sURL & "','" & sDescription & "'," & _
"'" & dDateAdded & "','N','" & iCategoryID & "','" & sContactName & "'," & _
"'" & sContactEmail & "','" & sKeywords & "','" & sTel & "','" & sFax & "','" & sUser & "','" & sPass & "')"

oConnection.execute(sSQL)

[Staff: Warren Ashcroft]

Yes, but you don't need to do them all - just the reserved ones.