Errr, rather that should be sum(bookcount) as bookcount, not sum(PBID) as PBID. Duh. > SELECT LEFT(PublicationYear, 4) AS Year, sum(Bookcount) as Bookcount
Cheers, Kris > SELECT LEFT(PublicationYear, 4) AS Year, sum(PBID) as PBID > You have to include category in your group by statement if you're > selecting it. And you need it in the view because you are limiting the > resultset based on it. Can you change your cfquery to something like: > > <cfquery name="qryGetYear" datasource="#request.site.dsn#"> > SELECT LEFT(PublicationYear, 4) AS Year, sum(PBID) as PBID > FROM dbo.PsycBOOKS > WHERE (IsNumeric(PublicationYear) = 1) > AND (Active = 1) > <cfif categories is not ""> > AND Category in (<cfqueryparam > cfsqltype="integer" list="true" value="#x#" />) > </cfif> > GROUP BY LEFT(PublicationYear,4) > ORDER BY Year desc > </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
