Lastaut
12 Aug 2009, 11:22 AM
The below cfloop returns data correctly but always repeat and outputs the last data cell. What am I doing wrong. For example, this information is outputed:
First, Second, Third, Third.
<CFLOOP INDEX="i" FROM="1" TO="#aat#">
<CFIF (#aat# GT #i#)>
<CFOUTPUT QUERY="systs" STARTROW="#i#" MAXROWS="#i#">
<FONT SIZE="-1">#test#, </FONT>
</CFOUTPUT>
<CFELSE>
<CFOUTPUT QUERY="systs" STARTROW="#i#" MAXROWS="#i#">
<FONT SIZE="-1">#test# </FONT>
</CFOUTPUT>
</CFIF>
</CFLOOP>
First, Second, Third, Third.
<CFLOOP INDEX="i" FROM="1" TO="#aat#">
<CFIF (#aat# GT #i#)>
<CFOUTPUT QUERY="systs" STARTROW="#i#" MAXROWS="#i#">
<FONT SIZE="-1">#test#, </FONT>
</CFOUTPUT>
<CFELSE>
<CFOUTPUT QUERY="systs" STARTROW="#i#" MAXROWS="#i#">
<FONT SIZE="-1">#test# </FONT>
</CFOUTPUT>
</CFIF>
</CFLOOP>