Compare record field with another record field of samerecordset

[WolfShade_2k]

:confused;

... but I don't know how to refer to field of next record in loop through recordset. Any ideas?

Thanks,

WolfShade

[adonis1976]

say your myQuery returned a bunch of numbers...then you would loop through the
query results and do the comparison inside the loop as follows..

<cfloop query="myQuery" index="i">
<cfif myQuery EQ myQuery[i+1]>
Do this
</cfif>
</cfloop>

[WolfShade_2k]

Originally posted by: adonis1976
<cfloop query="myQuery" index="i">
<cfif myQuery EQ myQuery[i+1]>
Do this
</cfif>
</cfloop>
So I can refer to the position within the returned recordset simply by
bracketing the index after the query name?? Like so;
<cfset ths=0>
<cfloop query="get_all_answers" index="idx">
<cfif get_all_answers[idx] eq get_all_answers[idx+1]>
<cfset ths = ths+1>
</cfif>
</cfloop>
<cfif ths gt 0><cfoutput>There are #ths# duplicates in the query</cfoutput>

Like that?

WolfShade
^_^

[adonis1976]

You are right.. your loop should work..