RE: Looping list in batch mode: best way?

2003-03-24 Thread Philip Arnold 
 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?

2003-03-24 Thread Ben Doom 
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