Brook Davies wrote: > Is it possible to update a row in a cached query? I want to do this when a > record in the cached record set is edited, as opposed to reloading/caching > the entire query. > > I tried: > > <cfset temp = querysetcell(attributes.query_name, "Company", "TestValue", > attributes.start)>
In CF 4.5 this used to work (at least without the 'attributes.' part). However, I presume it was a mistake that that worked, because the documentation has always claimed cached queries not to be updateable. I would take a look at the possibility of querying the cached query for all rows except the changed row (QoQ) and then doing a union with a manually created 1 row query with only the changed row. If union and querying QueryNew() queries is supported this really shouldn't be too hard. Jochem ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
