cfoutput with cfloop...

[fdgsogc]

I am trying to generate a unique code based on the number of records in two tables. I am using a cfloop within a cfoutput.
Here is my code.

<cfoutput query="getactivities">
<hr>
MainActivityID:#id#<br><br>
  <cfloop query="getaddresses">
  <cfset countertesta = countertesta +1>
  SubActivityID:#getactivities.id#&nbsp;
  CounterTestA:#countertesta#  <br>
  </cfloop>
</cfoutput>

This is giving me the following incorrect output.

MainActivityID:1

SubActivityID:1  CounterTestA:1 
SubActivityID:1  CounterTestA:2 

--------------------------------------------------------------------------------
MainActivityID:2

SubActivityID:1  CounterTestA:3 
SubActivityID:1  CounterTestA:4 

--------------------------------------------------------------------------------
MainActivityID:3

SubActivityID:1  CounterTestA:5 
SubActivityID:1  CounterTestA:6

The problem is that the SubActivity value should be the same as the MainActivity value.

Any ideas on how to correct this?

 

[ecobb]

<cfoutput query="getactivities">
[red]<cfset countertesta = 0>[/red]
<hr>
MainActivityID:#id#<br><br>
  <cfloop query="getaddresses">
  <cfset countertesta = countertesta +1>
  SubActivityID:#getactivities.id#&nbsp;
  CounterTestA:#countertesta#  <br>
  </cfloop>
</cfoutput>

Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[TruthInSatire]

Here is another thread ecar and i answered about looping nested queries.

thread232-1045543

Beware of programmers who carry screwdrivers.

 

[fdgsogc]

Thanks.

I decided not to include the ActivityID in the output since the counter is creating a unique code.

That's really all I needed.