Something like
SELECT DISTINCT Year([KidDate]) AS TheYear, Month([KidDate]) AS TheMonth
FROM tblKid
ORDER BY Year([KidDate]), Month([KidDate]);
Then you don't need the CF group at all. You will need MonthAsString().
Regards,
Matthew Walker
/*
Cabbage Tree Creative Ltd
Christchurch - New Zealand
http://www.matthewwalker.net.nz/
http://www.cabbagetree.co.nz/
*/
-----Original Message-----
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 9 April 2002 9:02 a.m.
To: CF-Talk
Subject: Date Problems Again :: Yet Another one
Yet Another Problem
i am trying to group by Month/Year
i just cant seem to get it.
i have read ever thing i can find in WACK
on group, GROUP BY, & CreateODBCDate
to no avail.
I have tried <cfoutput query="rsViewDate"
group="#LSDateFormat(rsViewDate.KidDate,'MMMM YYYY')#"> but that does
nothing good.
in this query.
i want it to show my dates entered
but on duplicates of the date.
so all the entrees for this month would just be in the select as April
2002
Thank You!
<cfquery name="rsViewDate" datasource="kid">
SELECT KidDate
FROM tblKid
GROUP BY KidDate
ORDER BY KidDate ASC
</cfquery>
<select name="KidDate" class="input">
<option value="">Select Date</option>
<cfoutput query="rsViewDate" group="KidDate">
<option
value="#rsViewDate.KidDate#">#LSDateFormat(rsViewDate.KidDate,'MMMM
YYYY')#</option>
</cfoutput> </select>
-paul
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
