CFOUTPUT & Columns

[riluve]

Try as I might, I can't figure this one out. Here is my simple implementation which is not exactly what I want.

<CFQUERY NAME="TEST" DATASOURCE="DB">
SELECT *
`Data` AS DATA,
`Catagory` AS CAT
FROM `TABLE`
</CFQUERY>
<table width="200" >
<CFOUTPUT QUERY= "TEST">
<tr>
<td>#HTTP#</td>
</tr>
</CFOUTPUT>
</table>

Of course this gives me one long colum. What I would like to do is place the 'DATA'in seperate columns in the output table based on the Catagory. So the output should look like this:

Cat1 Cat2 Cat3
DATA DATA DATA
DATA DATA DATA
DATA DATA DATA

Where should I start? In the SQL or the CFOUTPUT tag?

 

[riluve]

oopps, sorry, small mistake, here is a better updated example:

<CFQUERY NAME="TEST" DATASOURCE="DB">
SELECT *
`Data` AS DATA,
`Catagory` AS CAT
FROM `TABLE`
</CFQUERY>
<table width="200" >
<CFOUTPUT QUERY= "TEST">
<tr>
<td>#DATA#</td>
</tr>
</CFOUTPUT>
</table>

 

[imstillatwork]

http://www.lot-o-nothin.com/cfml/tutorials/index.cfm/id/6_8/

or

http://www.lot-o-nothin.com/cfml/tutorials/index.cfm/id/6_9/

or

http://www.lot-o-nothin.com/cfml/tutorials/index.cfm/id/6_17/

Kevin

http://www.lot-o-nothin.com/cfml/

 

[daNewfie]

Try This

<CFQUERY NAME="TEST" DATASOURCE="DB">
    SELECT *
    `Data` AS DATA,
    `Catagory` AS CAT
    FROM `TABLE`
</CFQUERY>
<table width="200" >
<CFOUTPUT QUERY= "TEST">
    <tr>
    <td>#DATA#</td>
    <CFIF TEST.CurrentRow MOD 3 IS 0>
           </TR>    <TR>                                </tr></CFIF></CFOUTPUT>
</table>

 

[ecobb]

But what happens if your last row only has 2 records? Then you won't have a closing <tr> tag, which is invalid HTML, and can actually cause the page not to display at all in some browsers. (BTW, in your example you close the <tr>, then open it but immediately close it agin without any <td> tags...)

This is what you need:

<table>
  <!--- Keeps track of the current number of TD cells displayed --->
  <cfset iCount = 0>
  <!--- Set this to the number of TD cells you want displayed --->
  <cfset tCount = 2>
  <cfoutput query="TEST">
     <cfset icount = icount+1>
     <cfif icount eq 1>
        <tr>
     </cfif>
     <td>#DATA#</td>
     <cfif icount eq tCount>
       <cfset icount = 0>
       </tr>
     </cfif>
  </cfoutput>
  <!--- Includes however many blank TD tags are needed to finish out and close the current TR --->
  <cfif icount NEQ tCount AND icount GT 0>
    <cfloop condition="icount LT tCount">
      <cfset icount = icount+1>
      <td>&nbsp;</td>
    </cfloop>
    </tr>
  </cfif>
</table>

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[imstillatwork]

check the links I posted, the one with the grouped results.

look over the other ones too, to get an idea of the html flow

my grouped output example does what you are talking about, but is made for lots more groups, so it runs in rows. if you only have 3 columns (GROUPS) than it will do what you want, modify it and make it yours.

Kevin

http://www.lot-o-nothin.com/cfml/

 

[imstillatwork]

ecar got it too...I though it was a quote of the original.



Kevin

http://www.lot-o-nothin.com/cfml/