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
