Looping list in batch mode: best way?
We are being passed a comma delimited list with thousands of records...want to break into batches of 100. With cfloop list=listname delimiters=, you can't specify a range of 1-100 can you? What is the best way to handle this situation? Idea is then we would then update the database table to reflect it has been used, and not use again, then rerun the query which returns a list by design. This seems long and overly complex. Thanks a million!! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looping list in batch mode: best way?
We are being passed a comma delimited list with thousands of records...want to break into batches of 100. With cfloop list=listname delimiters=, you can't specify a range of 1-100 can you? What is the best way to handle this situation? Idea is then we would then update the database table to reflect it has been used, and not use again, then rerun the query which returns a list by design. This seems long and overly complex. You could use ListToArray() and go through in blocks of 100 That way you can break it into whatever chunks you find works best for you ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looping list in batch mode: best way?
If it were me, I'd take the list and turn it into an array. You could then (for example) store the array in a persistent scope (ie session, client, application) and specify start and stop variables in a for-type loop. HTH. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] : Sent: Monday, March 24, 2003 11:54 AM : To: CF-Talk : Subject: Looping list in batch mode: best way? : : : We are being passed a comma delimited list with thousands of : records...want : to break into batches of 100. : : With cfloop list=listname delimiters=, you can't specify a range of : 1-100 can you? What is the best way to handle this situation? : : Idea is then we would then update the database table to reflect : it has been : used, and not use again, then rerun the query which returns a list by : design. This seems long and overly complex. : : Thanks a million!! : : Regards, : : Eric J. Hoffman : DataStream Connexion : www.datastreamconnexion.com : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4