Loop Dynamic results Horizontally 2

[RobHat]

Hi there I am hoping someone can shed some light on this for me, I have an SQL db which I want to display the data from horizontally on my page. Say 3 or 4 columns by however many rows. What tags and behaviours would I need to do this?

Rob

 

[r937]

you will need CFQUERY, CFOUTPUT, and CFIF

r937.com | rudy.ca

 

[Sarky78]

this should do it for you:

<cfquery name="qryData">
  your query
</cfquery>

<table border="0" cellpadding="0" cellspacing="0">
<tr>
  <cfoutput query="qryData">
    <td>#qryData.FieldName#</td>
      <cfif NOT (qryData.CurrentRow MOD 6)>
        </tr>
	<cfif qryData.CurrentRow NEQ qryData.RecordCount>
          <tr>
	</cfif>
      </cfif>
   </cfoutput>
</table>

Hope this helps!

Tony

 

[RobHat]

Thanks for the help guys, I got this working.

Regards

Rob