I think you need to add the "name=queryName" attribute to your <cfquery> tag.
> -----Original Message----- > From: Ernest Douglas [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 20, 2006 2:45 PM > To: CF-Newbie > Subject: problem with cookies and migration > > 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:1916 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
