I do this by using a SQL query like
SELECT datefield as X, information as Y
FROM table
ORDER by datefield
<cfoutput query="X">#X#, #Y#</cfoutput>
Contact me offlist and I can help further.
Robert
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 3:06 PM
Subject: Grouping Problem
> I'm sure at least one of you people have had this problem, and i'm pulling
> my hair out of here....
>
> I have a field which has a date/time value.
>
> ie : 4/3/2001 12:00:00 PM
>
> now there are tons of records for each day, but with different times.
>
> I am trying to output a list of the past 10 days. Grouped by the Day
only,
> not the time.
>
> I've tried to actually format the date field in my [group] functions in
the
> cfoutput like this...
>
> <cfoutput query="information" group="DateFormat("#information.Date#",
> "m/d/yyyy")#">
>
> but this gives me an error saying that the information in the query does
not
> match within the loop....
>
> Can someone help me on this one? I feel as though there is a really
simple
> answer, though i am clearly not seeing it....
>
> Thanks.
>
> Kevin
>
> ~~~~~~~~~~~~~~~~~
> Kevin Mansel
> Web Developer
> Fox Communications
> [EMAIL PROTECTED]
> DL : 425-649-1321
> C : 425-346-7221
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
