My idea would be to put a query with the same name on the page that updates the database. The new query will overwrite the cached one as long as the SQL is different, then the first time some one runs the real query it will re cache that one.
J. John Wilker Web Applications Consultant, and Author Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com "more people are killed by donkeys than by airplane crashes each year" -----Original Message----- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 11:46 AM To: CF-Talk Subject: Question About Query Caching Let's say I have a query that is cached ... Let's say a user adds a new item to the table called in the query. Now we all know that so long as the query is cached, the new item won't show up in the output. But what if I want it to show up right away? Is there a way to dump the current cache as soon as a new item is inserted, so that the query is re-cached the next time it is run with the new data included? I think I need to cache this query because it won't change too often, but it returns, right now, 8,000 rows, so even cached it's a little on the slow side. H. ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
