I'm sorry, I didn't indicate the line of code below generating the error is:
WHERE customerid LIKE '#cookie.shoppingcart_cookie#'
> Greetings. We are migrating a Cold Fusion 5 process using Access to
> Cold Fusion MX Using MySQL in a Linux environment. This is a ticket
> ordering process. At the end of the process, when the script tries to
> pull customer data from a database for an order summary, it pulls
> previous order information from the database. If you try to start over,
> when the cookie is used as customer id to clear the database, I get an
> error:
>
> Syntax error or access violation: You have an error in your SQL syntax
> near '* FROM temp_shopping_cart WHERE customerid LIKE
> 'NVCMKRICGDKOL89080'' at line 1
>
> for the following code -
>
> <CFOUTPUT>
> <CFIF ISDEFINED("cookie.shoppingcart_cookie") IS TRUE>
> <CFQUERY DATASOURCE="LIGHT2">
> DELETE *
> FROM temp_shopping_cart
> WHERE customerid LIKE '#cookie.shoppingcart_cookie#'
> </CFQUERY>
> <CFCOOKIE NAME="shoppingcart_cookie" VALUE="" expires="now">
> </cfif>
> </cfoutput>
>
> Any insights would be greatly appreciated.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:15/messageid:1918
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
