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.
John. -----Original Message----- From: Pablo Varando [mailto:[EMAIL PROTECTED]] Sent: 27 August 2002 01:52 To: CF-Talk Subject: Re: Recordsets for the whole site Try including a single page? Or maybe creating a custom tag that will do the required tasks and spit out the required recordsets to use in the application. That's probably the best way to do it. Not to mention that when you need to modify things, it's just one page :) Just in idea :) Pablo Varando http://www.cfpablo.com http://www.easycfm.com ----- Original Message ----- From: "Mitko Gerensky-Greene" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 26, 2002 5:37 PM Subject: Recordsets for the whole site > I am creating my first CF-enabled online database. > > I am starting to find it limiting that I have to define the same > recordset over and over in different pages. Is there a way of keeping > the results of a > recordset for use by more than a single webpage? > > Thanks in advance, > > Mitko Gerensky-Greene > > **************************************************************** > "Make no search for water. But find thirst, > And water from the very ground will burst." > (A Persian mystic poet, quoted in Delight of Hearts, p. 77) > > "The world is but one country and mankind its citizens" Baha'i Faith > http://www.us.bahai.org > ***************************************************************** > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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

