How to move to next record

[alagukannan]

Hi,
I am working on an application,that requires the records to be displayed in 2
columns..
So i need something like this..
<tr>
<td>recordsetvalue</td>
<td>nextrecordsetvalue</td>
</tr>

I am not sure how to the next recordset..is there any cursors in coldfusion
through which i can manualy move ot the next record..

Thx
AL

[alagukannan]

Hi,
I am using coldfusion 6.1 mx and oracle 9i.
I am using cfquery tag.


thx
AL

[SafariTECH]

Try using CFLOOP stepping by 2

i.e.
<tr>
<CFLOOP from="1" to="#query.recordcount#" index="ThisLoop" step="2">
<CFOUTPUT>
<td>query.column[ThisLoop]</td>
<td>query.column[ThisLoop + 1]</td>
</CFOUTPUT>
</CFLOOP>
</tr>

You may need to play with it a bit, but it should work.

[zoeski80]

Hi AL

You can loop over the whole query and then just close the row and start a new
one after every 2nd record. MOD 2 will return 0 if the value is 2 or 4 as there
is no remainder when dividing by 2 so that is when you want to do the </TR><TR>
bit.

This way you can modify the code to be MOD 3 or MOD 4 to have different number
of columns.

HTH

Zoe

<TR>
<CFLOOP QUERY="QueryName">
<TD>#ColumnOutput#</TD>
<CFIF CurrentRow MOD 2 EQ 0 AND NOT CurrentRow EQ RecordCount> <!--- for
items 2, 4 .. close the ROW tag and start a new row --->
</TR><TR>
</CFIF>
</CFLOOP>
</TR>

[alagukannan]

HI All,
Thx for helping...

with regards
AL