Following up on this question, I have viewed the query that is being passed into MySql via the Log file. I've run the query in a MySQL client and that works without a problem.
One last thing, It seems that there is some kind of extra character being added after the "this.id" value which looks like square. Ok, I don't think that this is the problem but maybe.... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jordan Thomas Sent: Wednesday, 9 July 2003 1:20 PM To: CFAussie Mailing List Subject: [cfaussie] RE: Strange behaviour with MYSQL That's the strange thing. I have alrady done this and it works without a problem. Also, it seems to be deleting from the 'standard_attribute_value' table but not the 'standard_attribute_value_translation' table. Really strange. I upgraded mySQL to the latest version but not the driver yet. I am just using the CF OEM driver for Mysql. Any more ideas? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Stanton Sent: Wednesday, 9 July 2003 1:02 PM To: CFAussie Mailing List Subject: [cfaussie] RE: Strange behaviour with MYSQL 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/ --- 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/
