year(entryDate) . Also don't worry about the cfoutput yet. First you need to
get the query looking right. Try cfdump first.
-----Original Message-----
From: Jake . [mailto:[EMAIL PROTECTED]
Sent: Monday, 12 January 2004 10:05 a.m.
To: CF-Talk
Subject: Re:Grouping problem on dates
>Just add the year to your group...
>
>select datepart('y',entryDate) as xYear,
>datepart('m',entryDate) as eMonth,
>count(*) as xcount
>from entries where entrystatus = 1
>group by datepart('y',entryDate),
>datepart('m',entryDate)
I just tried that and got the same results. The results of this query are
just a long list (in order of oldest to newest, as it should be) of every
entry in the entries table, not all of the January 2004 items grouped under
a "January 2004" item.
Any other ideas?
Thanks!
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
