CFOUTPUT QUERY 1 RECORD AT A TIME

Hello Experts,

I have a query (users) which I need to process one because the process the I have running for each user take about 5 to 10 seconds to process so I need to "step" thru one record at a time, run the process and then move to the next record.  I found that doing simple cfloop or cfoutput does work because it runs too quick and doesn't give suffient time for the process to run per user.

Here is what I'm trying but it doesn't work.

Thanks,

Anthony


<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfparam name="PageNum_billing" default="1">
<cfquery name="billing" datasource="rxnotifydb1">
select *
from users
</cfquery>

<cfset MaxRows_billing=1>
<cfset StartRow_billing=Min((PageNum_billing-1)*MaxRows_billing+1,Max(billing.RecordCount,1))>
<cfset EndRow_billing=Min(StartRow_billing+MaxRows_billing-1,billing.RecordCount)>
<cfset TotalPages_billing=Ceiling(billing.RecordCount/MaxRows_billing)>

<cfoutput query="billing" startRow="#StartRow_billing#" maxRows="#MaxRows_billing#">

#username#

<!--- Process Goes Here, it takes approx 5 to 10 seconds to complete per user --->

<cflocation url="#CurrentPage#?PageNum_billing=#Min(IncrementValue(PageNum_billing),TotalPages_billing)#">

</cfoutput>