Qasim Rasheed wrote: > I would say it's a bug as I can verify this on my local CFMX7 server. It > seems that if you have a DML statement i.e. delete,update or insert and you > have named that query and if you do a select query afterwards with the same > query name, CF copies the name to the variables scope. Really strange.
I can't try it right now, but it'd be interesting to see if the same thing would happen if you didn't name the DML query ... since DELETE and UPDATE statements don't actually return anything, if you try to access the named variable afterwords it is undefined. I suspect that all would be fine if: A - the DML query wasn't named or B - the two queries were both SELECT statements. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
