Syntax Error

[fatmbk]

Can anyone advise me on how to correct this apparent syntax error?

add = "INSERT INTO tblProducts (Name,Description,Category,Keywords,ImagePath,Price) VALUES ('"+name+"','"+description+"','"+category+"','"+keywords+"','images/"+image+"',"+price+")";

Cheers,

Fatmbk

 

[WhiteKnight57t]

Sure can but what program are you using?

possibly replace all + with &

==========================
Sorry to be terse
some say it's a curse
I know it's worse
I'm just diverse
-Tim

 

[fatmbk]

I'm using it in the context of ASP connecting to an Access database.

Thanks!

 

[JamesLean]

Suggest you post in the Access forum to find out what the final insert query should look like, then in the ASP forum if you're having problems building that from the ASP page.

--James