OK, I discovered that a) I posted in the wrong bit of the debug - the query after it was the one affected. The fact that it had the ? on it threw me a bit and stopped me looking at other causes, so I am afraid I jumped the gun rather. b) There was a problem relating to data and what was being passed, that once I fixed, things seem to be working fine now.
> 1) Shouldn't the cfqueryparam value be "#URL.cotid#" and not Attributes ? No - fuseBox pushes form and URL into attributes on every request so you dont have to mess around when you change a form to get / post. While I am here - I have read that using cfqueryparam gives a performance gain over not using it - is there any proof or technical data out there? An explanation over why/how it makes a query faster? Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
