Table has a Primary Key of DealerCode (UUID)
A form POSTs the required key ( form.txtDealer ) to be picked up by the
Details Update page.
My scripting for the Update Details page includes ...
<CFoutput >#form.txtDealer#</CFoutput>
<CFset matchDealer=Replace(#form.txtDealer#,'-','','all') />
<br /> <CFoutput >#matchDealer#</CFoutput>
<CFset vDealer= '' & #matchDealer# & '' />
Outputs from that are correct.
This query fails ...
<CFquery name="qUpdate" datasource="#appDSN#" >
SELECT *
FROM Dealers d
WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#;
</CFquery>
Errors are ...
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
''all')=4A1BC12D6C1D460FB50D7420A5BA306B' at line 3
The error occurred in /web/PurchaseOrders/update_Dealer.cfm: line 40
38 : SELECT *
39 : FROM Dealers d
40 : WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#;
41 : </CFquery>
SQL SELECT * FROM Dealers d WHERE
Replace(d.DealerCode,'-','','all')=4A1BC12D6C1D460FB50D7420A5BA306B;
--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12892 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321329
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
