Thank you very much, this worked just fine.
Kevin
---------- Original Message ----------------------------------
From: "Chris Stoner" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 06 Apr 2001 15:52:01 -0400
>You might be better served by doing something like this
>
>
><CFQUERY Name="queryName">
> SELECT DATEPART(day, DateColumn) AS 'GroupDate',
> DateColumn,
> OtherColumns
> ORDER BY DateColumn
></CFQUERY>
>
>
><CFOUTPUT Query="queryName" Group="GroupDate">
> #GroupDate#
> <CFOUTPUT>
> #OtherColumns#
> </CFOUTPUT>
></CFOUTPUT>
>
>
>-- Chris Stoner
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Friday, April 06, 2001 3:07 PM
>To: CF-Talk
>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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
