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!
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
