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