Whoops! My co worker just pointed out you have a "*" in your delete statement. You don't need that in the SQL. Just remove that and see what happens.
> -----Original Message----- > From: Ernest Douglas [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 20, 2006 4:15 PM > To: CF-Newbie > Subject: Re: problem with cookies and migration > > 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:1919 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
