Re: hello folks How to do paging on looping a list i was confused please help me

2008-04-22 Thread Paul Stewart 
or indeed my custom tag cfMagicpager.

http://www.stewart-web.co.uk/blog/index.cfm/2008/4/20/Cold

It is a different take than Nathan's on pagination.

Nathan Strutz wrote:
 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.

   


~|
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:303967
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

hello folks How to do paging on looping a list i was confused please help me

2008-04-21 Thread shariff sml 
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

Re: hello folks How to do paging on looping a list i was confused please help me

2008-04-21 Thread Nathan Strutz 
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