<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>
how to do Pagging on this Code i know how to do if i loop over a query
can any one help it out. this is because my data base i have over 1000 records
and coldfusion server time out occures thanks you floks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:303947
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
