Stuart Kidd wrote: > Oh MM, sort it out! > > Caching queries manually, how is that done?
You could store it in a struct in the APPLICATION scope, along with information identifying it and when it times out. It's not really a bug. Using <CFQUERYPARAM> with <CFQUERY> means that rather than a regular statement, CF is able to use prepared statements, so the execution plan (depending on the RDBMS you're working with) can be cached for extra execution speed. To cache with both, it's have to store the values passed into the CFQUERYPARAM tags, the prepared statement itself, and various other bits and pieces. They probably see it as being more trouble than it's worth. K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190275 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
