> 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.
Yes, both the CFQUERY tag attributes (name, datasource, username, password) and SQL must be identical. You can flush all cached queries using the CFOBJECTCACHE tag, however: <cfobjectcache action="clear"> Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
