At 01:48 PM 2/5/01 -0700, you wrote:
>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?
Somebody hasn't been paying attention to the "The BETA IS OUT!!! (query a
query)" thread.
No. Not until version 5.0, which is currently is Beta.
Now announcing my newly updated website
http://www.blivit.org/mr_urc/index.cfm
Resume: http://www.blivit.org/mr_urc/resume.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
