I have a query which returns a bit of data.
I'm trying to output the data via a table on the page
I'd like the output to look like
Terry Monroe, LA
Tarah Jacksonville, FL
Business Mike Raleigh, NC
Maria Charlotte, NC
Tim Charleston, SC
Natalie Salina, KS
Indirect Kay Longview, TX
the query returns
NAME LOC CNT Channel
Terry Monroe, LA 5 Business
Tarah Jacksonville, FL 5 Business
Mike Raleigh, NC 5 Business
Maria Charlotte, NC 5 Business
Tim Charleston, NC 5 Business
Natalie Tampa, FL 2 Indirect
Kay Little Rock, AR 2 Indirect
The CNT I can use as a rowspan, but how do I get this to display properly?
-----------------------------
<table>
<cfoutput query="qRpt" startrow="1" maxrows="1">
<tr>
<td
rowspan="#qRpt.cnt#">#qRpt.buschannel#</td><td>#qRpt.name#</td><td>#qRpt.loc#</td>
</tr>
</cfoutput>
<cfoutput query="qRpt" startrow="2">
<tr>
<td>#qRpt.name#</td><td>#qRpt.loc#</td>
</tr>
</cfoutput>
</table>
----------------------------------
doesnt work.. well it does up til the next Channel (business) which
doesnt get displayed.
I've also tried...
-----------------------------
<table border="1">
<cfoutput query="qRpt" group="buschannel">
<tr>
<td rowspan="#qRpt.cnt#">#qRpt.buschannel#</td><td>#qRpt.name#</td><td>#qRpt.loc#</td>
</tr>
<cfoutput>
<tr>
<td>#qRpt.name#</td><td>#qRpt.loc#</td>
</tr>
</cfoutput>
</cfoutput>
</table>
----------------------------------
this duplicates the first row... I'm stumped..
Can someone assist? it's appreciated!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
