Hi, I am using MYSQL as the DB for my app.
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> Strange thing is that when I execute the query in a MYSQL client, it works without a problem. Any ideas? thanks Jordan --- 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/
