If dbo.PsycBOOKS is a "view", you shouldn't need to include Category in the
cfquery select list. Totally untested, but something like this should work
<cfquery name="qryGetYear" datasource="#request.site.dsn#">
SELECT LEFT(PublicationYear, 4) AS [Year], COUNT(PBID) AS BookCount
FROM dbo.PsycBOOKS
WHERE IsNumeric(PublicationYear) = 1
AND Active = 1
<cfif categories is not "">
AND Category IN
(
<cfqueryparam value="#categories#" list="true" cfsqltype="...">
)
</cfif>
GROUP BY LEFT(PublicationYear, 4)
ORDER [Year] desc
</cfquery>
I'm curious. Why is PublicationYear a varchar column?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289175
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
