Hi Maureen, Thanks, that was it. I typically use cfqueryparam, but this was a one shot, non public clean up of some old database tables.
Appreciate the help. Rob On 14 Sep 2012 at 9:18, Maureen wrote: > > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5922 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
