cfloop startrow and endrow questions

[kuolung]

I would like to send out 10 emails at the time select from table with N results.

Is there an easy way to do with cfloop startrow and endrow dynamically, say when it completes first 10 records, it starts next 10, and so on or until it reaches recordcount?

thanks so much in advance for any helps.

 

[FALCONSEYE]

prolly something like :

<cfset recordsPerEmail = 100>
<cfparam name="StartRow" type="numeric" default="1">

<cfset totalRows = yourQuery.RecordCount>

<cfset endRow = MIN(StartRow + recordsPerEmail - 1, totalRows)>

then ...

<cfloop query="yourQuery" startrow="#StartRow#" endRow="#endrow#">

hope it helps...

http://www.fuzzysiberians.com

 

[kuolung]

FALCONSEYE, Much appreciated for your prompt response! I'll give it a try.