> Or store the recordset in an application scope variable. If you're using CF5 > then you could use query or queries to save on DB hits. > Sick puppy...... ;o) Don't be using Query of Query unless the data is coming from seperate datasources! Right your queries efficiently and properly in the first place and cache them appropriately!
Picking up a cached query is no slower than picking up a query from an application variable. Stephen ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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

