If this was based on the next x script here (I think it may have been) then
the "cacheing" was simply missed in the copy paste.
http://cfhub.com/discussion/viewmessages.cfm?Forum=11&Topic=422
Simply add the cache to the query:
cachedwithin="#CreateTimeSpan(0,0,10,0)#"
Note that that will make a "new" cache for every URL.ID that is requested so
likely the user will have to load that query at least the first time...
> Does anyone have a good query cache idea that would work with the example
> included?
>
> Thanks,
> Brandon
>
> ----- Original Message -----
> From: "Don Vawter" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, August 20, 2001 9:19 AM
> Subject: Re: Next and previous records
>
>
> > Just a couple of notes:
> > 1. Why not use a cached query so it doesn't reexecute on each page
> > 2. Be careful using a url parameter (url.id) in a query without first
> > validating it. You are leaving yourself open to hackers
> > (http://www.vawter.com/urlhack.cfm)
> >
> > ----- Original Message -----
> > From: "Michael Wilson" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, August 20, 2001 7:59 AM
> > Subject: RE: Next and previous records
> >
> >
> > > Thanks
> > >
> > > This is what I wound up going with. Seems to be working fine so far.
> > >
> > > ...thanks, Joseph.
> > >
> > >
> > > <CFQUERY NAME="GetRecords" DATASOURCE="xionmediacom">
> > > SELECT portfolio.*, media.*, clients.Client, portfolio.Description AS
> > > PortDesc
> > > FROM portfolio, media, clients
> > > WHERE portfolio.TypeID = #URL.ID#
> > > And portfolio.ID = media.PortfolioID
> > > AND portfolio.ClientID = clients.ID
> > > AND portfolio.ActiveStatus = 1
> > > AND media.ActiveStatus = 1
> > > ORDER BY clients.Client
> > > </CFQUERY>
> > >
> > > !---Assign default value for "start"--->
> > > <cfparam name="start" default="1">
> > >
> > > !---Assign default value for "display"--->
> > > <cfset display = 1>
> > >
> > > <!---Calculate the "next" value--->
> > > <cfset nextX = #start# + #display#>
> > >
> > > <!---Calculate the "previous" value--->
> > > <cfset PrevX = #start# - #display#>
> > > <cfif PrevX LTE 0>
> > > <cfset PrevX = 1>
> > > </cfif>
> > >
> > >
> > > <html>
> > > <head>
> > > <cfoutput><title>#title#</title></cfoutput>
> > > </head>
> > >
> > > <body>
> > >
> > > <!---Output results--->
> > >
> > > <h2>Results Page</h2>
> > >
> > > <cfoutput query="GetRecords" startrow="#start#" maxrows="#display#">
> > > #PortDesc#<br>
> > > </cfoutput>
> > >
> > > <!---Previous (X) (only show this link if there are "previous"
> > results)--->
> > >
> > > <cfif #start# is not 1>
> > > <cfoutput>
> > > <a
href="thispage.cfm?start=#PrevX#&display=#display#&ID=#URL.ID#">
> > > previous
> > > </a>
> > > </cfoutput>
> > > </cfif>
> > >
> > >
> > >
> > > <!---Next (X) (only show this link if there are more results
> > available)--->
> > >
> > > <cfif nextX LTE GetRecords.RecordCount>
> > > <cfoutput>
> > > <a
href="thispage.cfm?start=#nextX#&display=#display#&ID=#URL.ID#">
> > > next
> > > </a>
> > > </cfoutput>
> > > </cfif>
> > >
> > >
> > > </body>
> > > </html>
> > >
> > > >-----Original Message-----
> > > This one also takes "keyword" as a paramater... It may be closer to
what
> > you
> > > need. (even supports multiple columns)
> > >
> > > http://cfhub.com/discussion/viewmessages.cfm?Forum=11&Topic=422
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
