Cold Fusion, Why can't I get my previous and next page links to work?
<cfparam name="start" default="1">
<cfparam name="disp" default="5">
<cfqueary name="" datasource="">
SELECT
blah blah....
FROM
blah blah
</cfquery>
<cfset end = start + disp>
<cfif start + disp GT GetInfo.RecordCount>
<cfset end = 999>
<cfelse>
<cfset end = disp>
</cfif>
<cfoutput>
<cfif start NEQ 1>
<cfif start GTE disp>
<cfset prev = disp>
<cfset prevrec = start - disp>
<cfelse>
<cfset prev = start - 1>
<cfset prevrec = 1>
</cfif>
<a href="index.cfm?start=#prevrec#">«Previous #prev# Post's </a>
</cfif>
|
<cfif end LT GetInfo.RecordCount>
<cfif start + disp * 2 GTE GetInfo.RecordCount>
<cfset next = GetInfo.RecordCount - start - disp + 1>
<cfelse>
<cfset next = disp>
</cfif>
<a href="index.cfm?start=
#Evaluate("start + disp")#"> Next #next# Post's</a>
</cfif>
</cfoutput>
|