hi just testing connection to a mysql database using coldfusion mx
i can read and delete but cant insert using cfinsert or cfquery is there a problem i am not aware of.
error message is
Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near &apos;desc,photo) values (&apos;sSs&apos;,&apos;Ss&apos<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>&apos; at line 1
cant figure it out
any help apprecited

it's obviously an sql syntax error, so post your recordset and sql code, and someone should be able to help out.

regards

Dave Thomas
<b>DMX Zone Manager</b>