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=subscribe&forumid=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