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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
