How to point query result to the next record in a cfoutput?

[wminghao]

inside cfoutput, I output my SELECT query<br><br>&lt;cfoutput query=&quot;abc&quot;&gt;<br>&nbsp;&lt;tr&gt;<br>&nbsp;&nbsp;&lt;td&gt;<br>&nbsp;&nbsp;&nbsp;#abc.Name#<br>&nbsp;&nbsp;&lt;/td&gt;<br>&nbsp;&lt;tr&gt; <br>&lt;/cfoutput&gt;<br>&nbsp;<br>But I wish to disply two &lt;td&gt; in one &lt;tr&gt;, the second&nbsp;&nbsp;points to the next record of the query result.<br>&nbsp;&nbsp;&nbsp;<br>In ASP it is like:&nbsp;&nbsp;recordset.MoveNext<br>then the pointer is moved to the next record.<br><br>How to do in Coldfusion?<br><br><br>&nbsp;<br>

 

[DarkMan]

Here's how I do it...<br><FONT FACE=monospace><br>&lt;tr&gt;<br>&nbsp;&nbsp;&lt;cfoutput query=&quot;abc&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#name#<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfif currentrow mod 2 is 0&gt;&lt;/tr&gt;&lt;tr&gt;&lt;/cfif&gt;<br>&nbsp;&nbsp;&lt;/cfoutput&gt;<br>&lt;/tr&gt;<br></font><br>You can change the 2 to any number to get as many columns as you wish.