Grouping problem

Forum|Forum|20 years ago
April 14, 2006
4 replies
445 views

Hi Guys,

I have created two related tables that contain the following info:
Table1:
speakerID
speakerName
speakerReview
speakerImage

Table 2:
venueID
speakerID
venue
eventDate

I have managed to output data by grouping it with date and venue. But I can't in anyway get the data to show events in one row. i.e, if I've got 4 speakers performing in the same venue on the same date, I get the result of each speaker name individually listed in each row, four rows down. I want them to be in the same row sorted by the date and venue.

Any help would be very much appreciated..

Thanks
Rob

This topic is closed to new replies. Start a new post to keep the conversation going.

B

Bob-ElAuthor

Known Participant

Hey Mike,

I can't thank you enough, you're a star. Many thanks for your help....

Thank you

Rob

B

Bob-ElAuthor

Known Participant

Hello J Deline,

That's exactly what I need. The following code is what I'm working with:

<table id="tableLayout">
<cfoutput query="rsPrograms" group="eventdate">
<tr>
<td>#LSDateFormat(rsPrograms.eventDate)#</td>
<td> </td>
</tr>
<cfoutput>
<tr>
<td> </td>
<td><a href="details.cfm?ID=#rsPrograms.Speakers.speakerID#">#rsPrograms.speakerName#</a></td>

</cfoutput>
</cfoutput>
</table>

& No, I haven't got any eventID anywhere..

Many thanks for your help

Rob

A

Anonymous

Try the attached code....
(Note that data must be sorted by: eventDate, venue, then speakerName.)

A

Anonymous

I'm assuming you want something like this? Do you have an event id somewhere?

date 1 venue 1 speaker 1 speaker 2
date 2 venue 2 speaker 2 speaker 3 speaker 5
date 2 venue 1 speaker 7 speaker 8

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.