Business Terry Monroe, LA
Indirect Natalie Tampa, FL
On Mon, 16 Aug 2004 13:29:05 -0500, Greg Morphis <[EMAIL PROTECTED]> wrote:
> anyone have any ideas? I'm stumped
>
>
>
>
> On Mon, 16 Aug 2004 13:08:33 -0500, Greg Morphis <[EMAIL PROTECTED]> wrote:
> > I've got this right here
> >
> > <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>
> >
> > and it kinda works.. it's duplicating the first row though..
> >
> >
> >
> >
> > On Mon, 16 Aug 2004 14:03:19 -0400, dave <[EMAIL PROTECTED]> wrote:
> > > have u tried grouping yet?
> > >
> > >
> > >
> > > ---------- Original Message ----------------------------------
> > > From: Greg Morphis <[EMAIL PROTECTED]>
> > > Reply-To: [EMAIL PROTECTED]
> > > Date: Mon, 16 Aug 2004 12:55:02 -0500
> > >
> > > >Hey
> > > >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.
> > > >
> > > >Can someone assist? it's appreciated!
> > > >
> > > >
> > >
> > >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
