Hi Folks I'm cleaning up some old internal databases, some of the data from a query "workshop" of the old database is maintained while other parts are changed or update and then the results inserted into a new data base.
I keep running into the syntax error, which I can't figure out. What am I missing? thanks Rob Error Executing Database Query. 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 '@voyle.com,Seattle- May-12)' at line 2 The error occurred in line 71 69 : <cfquery datasource="appreciativeway"> 70 : INSERT INTO participantsNew (invoiceNumber,participantName,emailAddress,programCode) 71 : values (#invoiceNumber#,#workshop.participantName#,#workshop.emailAddress#,#p rogramCode#) 72 : </cfquery> 73 : VENDORERRORCODE 1064 SQLSTATE 42000 SQL INSERT INTO participantsNew (invoiceNumber,participantName,emailAddress,programCode) values (1,VoyleRobert,[email protected],Seattle-May-12) DATASOURCE appreciativeway ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5918 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
