well, obviously my examples didn't show up correctly just now...sorry, i didn't
know my table wouldn't take...
>Hi,
>
>I'm sure my problem isn't a hard one, but I'm somewhat new to CF and any
>help would be certainly useful. I'm creating a dynamic six-month calendar
>for a course schedule. It displays the id, name, day range, and location
>of each course, which pulls from the this query:
>
>SELECT QEBrazilCourses.id, QEBrazilCourses.myName, QEBrazilCourses.Hours,
>QEBrazilCourses.Days, QEBrazilCourses.Weblink, QEBrazilDates.id,
>QEBrazilDates.myDate, QEBrazilDates.Location
>FROM QEBrazilCourses, QEBrazilDates
>WHERE (QEBrazilCourses.id = QEBrazilDates.id)
>AND (month(QEBrazildates.myDate) BETWEEN month(now()) AND month(now()) +
>5)
>ORDER BY #sortBy#, myDate ASC
>
>
>It outputs as follows:
>
><cfoutput query="qeCoursesA" group="id">
><p><a href = "#qeCoursesA.Weblink#">#qeCoursesA.id# -
>#qeCoursesA.myName#</a></p> <!---Outputs course id, name, and links them
>to the appropriate file--->
><table>
> <tr>
> <td valign="top" bgcolor="eeeeee"><!---Outputs the day range and
>location of each course--->
> <p><cfoutput>#DateFormat(qeCoursesA.myDate, 'dd')#<cfif
>#dateformat(dateadd("d", qeCoursesA.Days-1, qeCoursesA.myDate), "dd")# EQ
>#dateformat(qeCoursesA.myDate, "dd")#><cfelse>-#dateformat(dateadd("d",
>qeCoursesA.Days-1, qeCoursesA.myDate), "dd")#</cfif> -
>#qeCoursesA.Location#<br></cfoutput></p>
> </td>
> </tr>
></table>
> </cfoutput>
>
>So far, my day range and location is correctly displayed under each
>course. This is how it looks right now:
>
>
>February
>March
>April
>Course ID/Course Name
>15-20 Houston
>25-29 Houston
>1-5 New Orleans
>10-12 San Diego
>10-15 Washington, D.C.
>6-9 Orlando, FL
>
>
>
>
>However, I need to go one more step beyond that and group those dates by
>month, but I'm not sure how to do it. This is how it should look:
>
>
>February
>March
>April
>Course ID/Course Name
>15-20 Houston
>25-29 Houston
>1-5 New Orleans
>10-12 San Diego
>10-15 Washington, D.C.
>6-9 Orlando, FL
>
>I tried doing a separate query until I found out you can't nest cfoutput
>tags. Then, I tried doing a cfloop inside a cfoutput, but it didn't seem
>to work correctly. Can someone give me a tip on solving this?
>
>Thanks very much,
>Lan Mai
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3347
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
