> Can I make an enormous cached query, and then query those
> results? Say, for example, I wanted to query all customers and
> all invoices at once, then display a list of customers with
> unpayed invoices, linked with URL variables to a detail page that
> would show the invoice details. Could I do this with one big
> query, cached at the beginning, and never hit my database again
> until the cache expired?
With CF4.x you'd have to loop through the query to display what you want
(more on the CF server than the database server)
In CF5 you'll be able to query a query, i.e. trim down the query results
with SQL
BTW, I don't think I'm breaking the CF5 NDA as Jeremy told the CFUG about it
a month or so ago...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
