Using MOD or maths help

Associate
Joined
19 Jul 2006
Posts
1,847
Is this the way to go ?

Im creating a dynamic table been populated by info from a database.

In my table i want 9 rows returned from the database query and an extra one that i need to do a calculation on. Then i need it to go to the next coloum

Code:
<cfif qryGetReport.currentRow[COLOR="Red"]+1 MOD 10 EQ 0[/COLOR]>
                </tr>
                <cfset variables.newrow = 1>
        <cfelse>
                <cfset variables.newrow = 0>
        </cfif>
What numbers do i need in the red bit
TIA
 
Back
Top Bottom