Thanks, Jesse! That did it!
I thought I had tried every combination of quotes, no quotes, and double-quotes... but, naturally, I hadn't tried the right one! Rick -----Original Message----- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 7:35 PM To: CF-Talk Subject: Re: Why doesn't this update query work? Rick Faircloth wrote: >Hi, everyone. > >Just installed MySQL for the first time and trying to learn to use it. > >Why won't this query update work? > > ><CFQUERY Name="UpdateText" Datasource="#DSN1#"> > Update Welcome W > Set "WelcomeText"='#Form.WelcomeText#' > Where W.BusinessID=#Request.BusinessID# ></CFQUERY> > > >I get this error: > >ODBC Error Code = 42000 (Syntax error or access violation) > > >[TCX][MyODBC]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 >'"WelcomeText"='Whether you are moving across town or across > >Thanks! > > try removing the doublequotes around Welcometext Jesse ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
