Hey guys.
i know i have found out how to do this befor, but cant track down the post..
i have a record set, its returnning 5 out of 9 records..
page 1 of 2 records 1-5..
i can sort asc/desc
<a href="default.cfm?DOrderby=<cfif URL.DOrderby EQ "UserID
Asc">UserID Desc<cfelse>UserID Asc</cfif>">ID</a>
but when i click again it gives me records 5-9 desc
which ould be fine. but i would like to it to just give me records 5-1
i have tried puting the paging infor in the href.. but cant seem to be
able to nail it.
any help would be great!
thanks!
the paging vars
<cfset MaxRows_getUsers=5>
<cfset
StartRow_getUsers=Min((PageNum_getUsers-1)*MaxRows_getUsers+1,Max(getUsers.RecordCount,1))>
<cfset
EndRow_getUsers=Min(StartRow_getUsers+MaxRows_getUsers-1,getUsers.RecordCount)>
<cfset TotalPages_getUsers=Ceiling(getUsers.RecordCount/MaxRows_getUsers)>
<cfset QueryString_getUsers=Iif(CGI.QUERY_STRING NEQ
"",DE("&"&XMLFormat(CGI.QUERY_STRING)),DE(""))>
<cfset tempPos=ListContainsNoCase(QueryString_getUsers,"PageNum_getUsers=","&")>
<cfif tempPos NEQ 0>
<cfset QueryString_getUsers=ListDeleteAt(QueryString_getUsers,tempPos,"&")>
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287980
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
