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

Reply via email to