SELECT theTitle, theDate
FROM theTable
ORDER BY theDate
</cfquery>
<cfoutput query="qTest" group="theDate">
== #DateFormat(qTest.theDate,"mmmm d")# ==<br>
<cfoutput>
- #qTest.theTitle#<br>
</cfoutput>
</cfoutput>
Pascal
> -----Original Message-----
> From: Jake McKee [mailto:[EMAIL PROTECTED]
> Sent: zaterdag 3 april 2004 9:04
> To: CF-Talk
> Subject: Grouping help
>
> I'm trying to run a query then tag each day of the query with a title.
> Something like:
>
>
>
> == March 1 ==
>
> - Entry 1
>
> - Entry 2
>
> - Entry 3
>
>
>
>
>
> == March 2 ==
>
> - Entry 4
>
> - Entry 5
>
>
>
> == March 7 ==
>
> - Entry 6
>
> - Entry 7
>
>
>
> Any ideas how to do this?
>
> Thanks!
> Jake
>
>
>
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
