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