> 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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
