Shariff, I don't know exactly what you are attempting to do, but if you are looking for a way to page your data, you may want to look into my Pagination.cfc project. http://paginationcfc.riaforge.org/
If that's not it, perhaps you can elaborate your problem, with the overview, what your goal is, what you have tried, what you get output from that code and why it has failed? 1000 rows in a database table should not be a problem. I have had tables with millions of rows. -- nathan strutz http://www.dopefly.com/ On Mon, Apr 21, 2008 at 4:52 PM, shariff sml <[EMAIL PROTECTED]> wrote: > <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:303955 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
