Hi Scott, Try creating a query in your output location like this:
<cfquery name="T-Shirt_1" datasource="server name"> SELECT * FROM table name WHERE TshirtOption = 'T-Shirt 1' </cfquery> Then put this code where you want the count to appear. <cfoutput>#T-Shirt_1.recordcount#</cfoutput> You will have to create a query & output for each shirt option. Will that work for you? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5349 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
