That makes sense, thanks Dave :) I'm calling it a night (9:30pm my time), I'll get back to it tomorrow. FYI, the query was cached with the cached within attribute so I guess I'll have to flush it.
Have a good night Brook At 12:18 AM 18/08/02 -0400, you wrote: > > Is it possible to update a row in a cached query? > >No, not if you mean queries cached using CACHEDWITHIN/CACHEDAFTER in the >CFQUERY tag. > > > I tried: > > > > <cfset temp = querysetcell(attributes.query_name, "Company", > > "TestValue", attributes.start)> > > > > Which generated a java error. And I also tried: > > > > <cfset > > Variables[attributes.query_name]["company"][attributes.start]= > > "TestValue"> > > > > Which did not generate an error but did not update the cached > > query either. I think the scope is wrong. Anybody done this > > before? > >If you're trying to change the value of a query cell from a custom tag, and >the query exists in the calling page, you should pass the query itself as an >attribute, not just the name of the query: > ><cfquery name="qFoo" ...> >.. ></cfquery> > ><cf_changesomecellinaquery myquery="#qFoo#"> > ><!--- inside the custom tag ---> ><cfset temp = QuerySetCell(Attributes.myquery, ...) > >Note that you still can't change a cached query, but in general you can >change a value within a query object this way. In fact, to be technically >correct, you should be able to change a value within a cached query, but the >change will only affect the page in which the change was made, which doesn't >get you where you're trying to go. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
