Thanks Tim, It is strange though that this query works in the Mysql client but no through CF. I actually want to delete from multiple tables but I just cut the query down a bit to simplify it so I would prefer to use this syntax for now. Super frustrating! Is mysql just not up to scratch? I have been using it now for the last year and a bit with no problems....unitl now....
>:O( -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tim Sent: Wednesday, 9 July 2003 3:06 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Strange behaviour with MYSQL How about: DELETE FROM standard_attribute_value_translation savt WHERE EXISTS ( SELECT sav.id FROM standard_attribute_value sav WHERE sav.id = savt.standard_attribute_value_id_fk AND sav.standard_attribute_id_fk = <cfqueryparam value="#this.id#" cfsqltype="CF_SQL_INTEGER"> ); - timmah Jordan Thomas spoke the following wise words on 9/07/2003 8:09 PM EST: >When I try to run the following <cfquery> nothing happens. It throws no >error but the data is still there. > ><cfset this.id = 5> > ><cfquery name="qDeleteTranslations" datasource="scoop"> > DELETE standard_attribute_value_translation > FROM standard_attribute_value_translation savt, standard_attribute_value >sav > WHERE savt.standard_attribute_value_id_fk = sav.id > AND sav.standard_attribute_id_fk = <cfqueryparam value="#this.id#" >cfsqltype="CF_SQL_INTEGER" maxlength="8"> ></cfquery> > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
