You need quotes around the non-numeric fields in the query. values (#invoiceNumber#,'#workshoparticipantName#','#workshop.emailAddress#',#programCode#)
On Fri, Sep 14, 2012 at 9:13 AM, Rob Voyle <[email protected]> wrote: > > 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:5919 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
