Try running: <cfquery name="qDeleteTranslations" datasource="scoop"> SELECT 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>
<cfdump var="#qDeleteTranslations#"> and see what happens. Cheers Mark ______________ Mark Stanton Web Production Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 http://www.gruden.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/
