So both the SQL (all statements) and the Query NAME must be IDENTICAL to the cached query?
I would rather just run a blank (bare-bones SQL statement that returns just one or zero records) because the actual query returns 8,000 records and takes a few seconds to execute. H. > -----Original Message----- > From: Brian Scandale [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 2:18 PM > To: CF-Talk > Subject: RE: Question About Query Caching > > Now I'm a bit confused... > > I thought that as long as the query had not expired that cf would return > the cashed results... regardless of which page called the query... > particularly if the query name and slq were identical. > > ??? am I getting marauded by a donkey? > > > At 01:36 PM 3/13/02 -0800, you wrote: > >LOL. Oops, yeah I sure did. My bad. > > > >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: Bud [mailto:[EMAIL PROTECTED]] > >Sent: Wednesday, March 13, 2002 1:27 PM > >To: CF-Talk > >Subject: RE: Question About Query Caching > > > > > >On 3/13/02, John Wilker penned: > >>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. > > > >You mean as long as the SQL is IDENTICAL. > >-- > > > >Bud Schneehagen - Tropical Web Creations > > > >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > >ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] > >http://www.twcreations.com/ 954.721.3452 > > > > > ______________________________________________________________________ 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=coldfusiona 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
