ascal
> -Original Message-
> From: Mark Henderson [mailto:[EMAIL PROTECTED]
> Sent: 28 September 2004 04:49
> To: CF-Talk
> Subject: [Spam?] RE: Grouping Output Query Display
>
> Perfect
> I'd actually simplified it down and had it working (outside of us
Perfect
I'd actually simplified it down and had it working (outside of using tables for layout)
like so..
#month#
#date#
#time# - #agenda#
but you've kept it in tables for me with the correct display. The alternating colours are no big deal, and I've
Almost; write one row for the Meeting Date / time and then use your final
cfoutput with no group to write each agendum in subsequent rows (the thisrow
increment won't be in the right place now but you'll figure it out - you
might instead use meetingAgenda.CurrentRow but it depends on exact;y what
hi James,
I already tried that but it's possible I screwed it up...
I tried
Meeting Agenda #month# #year#
#date#
#time#
#agenda#
which outputs
Meeting Agenda August 2004
Tuesday t
Nest another group to the output for the meeting, like you did for the
month.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
So I have a query that's outputted and grouped by a particular column. In this case it's a meeting agenda grouped by month, which is what I want and this part is working fine. The problem is that in the output there are several instances of the date column that are repeated, and I'd prefer it to on
Actually, he is using oracle and LEVEL is a system column when using
CONNECT BY. It doesn't have to exist in the table.
> -Original Message-
> From: Nando [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 7 mei 2004 10:13
> To: CF-Talk
> Subject: RE: grouping output
>
Peters [mailto:[EMAIL PROTECTED]
Sent: Friday, May 07, 2004 9:14 AM
To: CF-Talk
Subject: RE: grouping output
Use "level" to determine the output
SELECT *, LEVEL
FROM NAVMENU
START WITH MNUPARENT = 0
CONNECT BY PRIOR MNUPARENT=MNUCHILD
#RepeatString("- ",qMenu.level)# #qMen
age-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 7 mei 2004 0:45
> To: CF-Talk
> Subject: grouping output
>
> I'm wanting to dynamically create a menu.
> My table has 6 columns.
> MNUITEMNUM (primary key - increments on insert), MNUPARENT
I'm wanting to dynamically create a menu.
My table has 6 columns.
MNUITEMNUM (primary key - increments on insert),
MNUPARENT (the parent menu id),
MNUCHILD (the child menu id),
MNUURL (the link associated with the menu item),
MNUDISP (what's displayed as the menu item),
MNUWIN (determines whet
10 matches
Mail list logo