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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
