can you provide a few rows from your table as an example? and your DBMS? On 1/19/07, Richard Cooper <[EMAIL PROTECTED]> wrote: > Hi all, > > I have an online poll which allows users to add the answers to the database. > > I can get the results like this: > <cfquery name="getData" datasource="#ARGUMENTS.DSN#"> > SELECT ,PL.question > ,PR.questionAnswer > FROM polls as PL > LEFT OUTER JOIN > pollResults as PR > ON PL.pollID = PR.pollID > AND PR.active = '1' > WHERE PL.active = '#ARGUMENTS.active#' > </cfquery> > > Ideally I'd like to be able to count the answers within the SQL, but I'm > getting stuck because the questionAnswer varies from question to question. Is > there a way to tally this up? > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
