ok..
i am using the jquery pager for pagnation.
my problem, is under one way a user can get to the result set i can
have over 2400 results.
but my pager will only show 100 max at a time.
but the page loads slowly due to all the returned rows..
how could i use maxrows to limit the result set, but say grab the next
100 or 500 records?
<cfquery name="get_it" datasource="#request.dsn#">
Select *
From tbl_it
<cfif>bunch of nasty stuff</cfif>
</cfquery>
<!--- Start Page Numbers --->
<div id="pager" class="pager">
<form>
<img src="/common/jquery/images/first.png" class="first"/>
<img src="/common/jquery/images/prev.png" class="prev"/>
<input type="text" class="pagedisplay"/>
<img src="/common/jquery/images/next.png" class="next"/>
<img src="/common/jquery/images/last.png" class="last"/>
<select class="pagesize">
<option value="10">10</option>
<option selected="selected" value="25">25</option>
<option value="50">50</option>
<option value="100">100</option>
</select>
</form>
</div>
<!--- END Page Numbers --->
<cfif get_it.recordcount gt 0>
<cfoutput>stuff here
<cfloop query="get_it">
more stuff
</cfloop>
</cfoutput>
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324043
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
