How to span a query into 2 columns

[CRC]

I have a query that produces a list of products and some of those products are
subdivided into groups within the list. I have a query that includes the
'Group' feature to display the products that are subdivided by their group.
This all works out fine but my problem is the list can be very long and I would
like to span the query into two columns. Attached is my code. Can anyone help
me?:confused;

<div align="left">
<table width="450" border="0" cellspacing="2" cellpadding="2">
<tr>
<th width="442" valign="top" scope="row"> <cfoutput><span
style="font-weight: bold; font-size:
larger;">#Recordset2.Products#</span></cfoutput><cfoutput query="Recordset1"
group="Subtype">
<div align="left" style="font-size: larger"> <br>#Recordset1.SubType#</div>
<cfoutput>
<div align="left"><span style="font-size:
x-small">&nbsp;&nbsp;#Recordset1.Product#
</span><br>
</div>
</cfoutput></cfoutput><br></th><tr> </tr>
</table>
<p><strong><span class="style11"><br>
</span></strong></p>
</div>

[CRC]

I have a query that produces a list of products and some of those products are
subdivided into groups within the list. I have a query that includes the
'Group' feature to display the products that are subdivided by their group.
This all works out fine but my problem is the list can be very long and I would
like to span the query into two columns. Attached is my code. Can anyone help
me? :confused;

<div align="left">
<table width="450" border="0" cellspacing="2" cellpadding="2">
<tr>
<th width="442" valign="top" scope="row"> <cfoutput><span
style="font-weight: bold; font-size:
larger;">#Recordset2.Products#</span></cfoutput><cfoutput query="Recordset1"
group="Subtype">
<div align="left" style="font-size: larger"> <br>#Recordset1.SubType#</div>
<cfoutput>
<div align="left"><span style="font-size:
x-small">&nbsp;&nbsp;#Recordset1.Product#
</span><br>
</div>
</cfoutput></cfoutput><br></th><tr> </tr>
</table>
<p><strong><span class="style11"><br>
</span></strong></p>
</div>

[CRC]

I have a query that produces a list of products and some of those products are
subdivided into groups within the list. I have a query that includes the
'Group' feature to display the products that are subdivided by their group.
This all works out fine but my problem is the list can be very long and I would
like to span the query into two columns. Attached is my code. Can anyone help
me? :confused;

<div align="left">
<table width="450" border="0" cellspacing="2" cellpadding="2">
<tr>
<th width="442" valign="top" scope="row"> <cfoutput><span
style="font-weight: bold; font-size:
larger;">#Recordset2.Products#</span></cfoutput><cfoutput query="Recordset1"
group="Subtype">
<div align="left" style="font-size: larger"> <br>#Recordset1.SubType#</div>
<cfoutput>
<div align="left"><span style="font-size:
x-small">&nbsp;&nbsp;#Recordset1.Product#
</span><br>
</div>
</cfoutput></cfoutput><br></th><tr> </tr>
</table>
<p><strong><span class="style11"><br>
</span></strong></p>
</div>

[Brian Hogue]

The parameter for spanning columns is "colspan". You want "colspan=2" on
some rows.

-brian

"CRC" <webforumsuser@macromedia.com> wrote in message
news:d07dsi$9a1$1@forums.macromedia.com...

> I have a query that produces a list of products and some of those products

are

> subdivided into groups within the list. I have a query that includes the
> 'Group' feature to display the products that are subdivided by their

group.

> This all works out fine but my problem is the list can be very long and I

would

> like to span the query into two columns. Attached is my code. Can anyone

help

> me? :confused;
>
> <div align="left">
> <table width="450" border="0" cellspacing="2" cellpadding="2">
> <tr>
> <th width="442" valign="top" scope="row"> <cfoutput><span
> style="font-weight: bold; font-size:
> larger;">#Recordset2.Products#</span></cfoutput><cfoutput

query="Recordset1"

> group="Subtype">
> <div align="left" style="font-size: larger">

<br>#Recordset1.SubType#</div>

> <cfoutput>
> <div align="left"><span style="font-size:
> x-small">&nbsp;&nbsp;#Recordset1.Product#
> </span><br>
> </div>
> </cfoutput></cfoutput><br></th><tr> </tr>
> </table>
> <p><strong><span class="style11"><br>
> </span></strong></p>
> </div>
>

[CRC]

I apologize in advance for my inexperience, but where in my code do I put that. I tired putting it after 'scope='row'' but that did nothing...?

[Tteddo]

You would use 2 cfloops, an outside one that would index the row every 2
records and then 2 query loops inside that one, one for each <td>. So, every
row you would add 1 to a Row_Number variable, which would add the required <tr>
and </tr>, and also you would index 2 record variables by 2, which you would
use to snag every other record from the database and add the <td>'s Like so
<cfset Total_Rows = Total Records / 2 + 1> <cfset Row_Number = 1> <cfset
Record_One = 1> <cfset Record_Two = 2> <cfloop condition='Row_Number less than
Total_Rows'> <tr> <cfloop query='get_data' startrow='#Record_One#'
endrow='#Record_One#'> <td> #Data# </td> </cfloop> <cfloop query='get_data'
startrow='#Record_Two#' endrow='#Record_Two#'> <td> #Data# </td> </cfloop>
<cfset Row_Number = Row_Number + 1> <cfset Record_One = Record_One + 2> <cfset
Record_Two = Record_Two + 2> </cfloop>

[Brian Hogue]

CRC -

No need to apologize, most people need help in the beginning.

Your question is really a HTML question, not a CF question. The tags for
displaying a table are <table>, <tr> and <td>. The <td> "defines" the cell.
Since you want one cell to span two columns, that HTML tag looks like <td
colspan="2">.

I am guessing that you want to span two columns in certain instances, and in
other rows you want the two columns to appear. That sounds like some
tweaking of any CFloop and CFoutput code that you have. Have you read Ben
Forta's WACK?

-brian


"CRC" <webforumsuser@macromedia.com> wrote in message
news:d07tcb$5ts$1@forums.macromedia.com...

> I apologize in advance for my inexperience, but where in my code do I put

that. I tired putting it after 'scope='row'' but that did nothing...?

[CRC]

I got a response from an instructor of mine which solved my problem. Here is
is response for future reference: I am assuming that you want to place the
products into two column, e.g. Auto Dealers Auctions
Franchised Auto Dealer Implement &amp; Equipment
Motorcycle &amp; RV Dealership Trailer Dealers
Used Car &amp; Truck Repair Shops Body &amp; Paint
Mechanical Mobile Repair
Muffler Radiator Wheel Alignment
There are two approaches: 1 w/ tables, 1 w/ divs. Looking at your code, the
div solution looks better: <CFOUTPUT query='Recordset1' group='Subtype'>
<DIV align='left' style='font-size: larger'><BR>#Recordset1.SubType#</DIV>
<CFOUTPUT> <DIV align='left; font-size: x-small; width:48%;
float:left'> #Recordset1.Product#<BR> </DIV> </CFOUTPUT>
</CFOUTPUT>