Hi,
I am using MYSQL as the DB for my app.
When I try to run the following <cfquery> data is deleted from the
standard_attribute_value table but standard_attribute_value_translation is
left untouched. It throws no error but the data is still there. Actually,
<cfset this.id = 5>
<cfquery name="qDeleteTranslations" datasource="scoop">
DELETE standard_attribute_value_translation.*, standard_attribute_value.*
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>
I have checked the MySql log file and the query is being passed in OK but
there is a Sqare after the "this.id". I am not sure whether or not that
matters. I am also getting some strange problems when using the IN operator
not unlike this one. For instance:
<cfquery name="qDeleteAttributeTranslation" datasource="scoop">
DELETE
FROM standard_attribute_value_translation
WHERE standard_attribute_value_id_fk IN
(#valueList(qGetAttributeValue.id)#)
</cfquery>
This also doesn't delete any rows although
"valueList(qGetAttributeValue.id)" is equal to "1,2,3" which corresponds to
records in the table.
Strange thing is that when I execute the query in a MYSQL client, it works
without a problem. Is this a problem with MySql, The MySql driver that comes
with CF or CF itself (although unlikely). Is this a common happening for
others?
Any ideas?
thanks
Jordan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
