I trying to write some SQL that will efficiently return information to create a web poll results graph. The database has 1 field, "pollresponse", which will contain 1 of 3 possible answers. I have these answers, and can use them in the query if necessary.
How can I query this table and find out 1) the total number of submission where the field is not empty, 2) the number of votes for any of the 3 possible responses. Is there some way I can do this with one query? If there is, I can't find it... Thanks for the assist! Brook ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
