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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
