<cfset attributes.ids = ValueList(GetAllAdmins.Author)>
<cfset attributes.perm = ValueList(GetAllAdmins.IsAdmin)>
<cfset adminQueryRaw = QueryNew("empid,lastname,firstname,status")>
<cfset badIDs = "">
<cfloop from="1" to="#ListLen(Attributes.ids)#" index="ThisPlace">
<cfscript>
thisemployeeid = listgetat(attributes.ids, thisplace);
thisperm = listgetat(attributes.perm, thisplace);
</cfscript>
<cfmodule
template="#Request.CFRoot#/authentication/act_UserInfoFromEmpNumber.cfm"
employeeid="#ThisEmployeeID#">
<cfscript>
if (len(lastname) AND QueryAddRow(adminQueryRaw)) {
QuerySetCell(adminQueryRaw, "empId", thisemployeeid);
QuerySetCell(adminQueryRaw, "lastname", LastName);
QuerySetCell(adminQueryRaw, "firstname", FirstName);
if (ThisPerm is 1)
QuerySetCell(adminQueryRaw, "status", "Full Administrator");
else
QuerySetCell(adminQueryRaw, "status", "Reporting Only");
} else {
badIDs = ListAppend(badIDs,"'#thisemployeeid#'");
}
</cfscript>
</cfloop>
<cfinvoke component="#Request.CFROOT#/CFCs/utility" method="bubbleSortQuery"
qryinput="#adminQueryRaw#" lstsortcolumns="LastName,FirstName"
lstsortorder="asc,asc" returnvariable="adminQuery">
<cfif listLen(badIDs)>
</cfif>
AS i have over 1000 records in my database the coldfusion server is timed out
so can any one help me how to pagging on this code
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303946
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
