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/
