how about this. i'm making an assumption about how you're getting your 1-5
list:
<cfquery name="getPoll">
select myValue
from myTable
order by myValue
</cfquery>
<cfoutput query="getPoll" group="myValue">
<cfquery name="getVotes">
SELECT COUNT(myValue) AS Whatever
FROM myTable
WHERE myValue = #getPoll.myValue#
</cfquery>
#getPoll.myValue#: #getVotes.Whatever# times
<cfset percent = (getVotes.Whatever/ getPoll.RecordCount) * 100>
#percent# %
</cfoutput>
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
----------------------------------------------------------------------
Get your domain names online from:
http://www.alienationdomains.co.uk
Reseller options available!
----------------------------------------------------------------------
----------------------------------------------------------------------
"Damian Watson"
<[EMAIL PROTECTED] To: <[EMAIL PROTECTED]>
ign.co.uk> cc:
Subject: Re: [ cf-dev ]
percentages of values in recordset
11/06/2003 15:45
Please respond to dev
That bit's easy enough. The column I'm selecting records from has 5
possible
values (1-5). I'm trying to count the number of times the value appears in
the column's recordset without writing 5 queries with the where clause.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 3:40 PM
Subject: Re: [ cf-dev ] percentages of values in recordset
>
> (query.Whatever / query.RecordCount) * 100
>
> ???
>
>
> Duncan Cumming
> IT Manager
>
> http://www.alienationdesign.co.uk
> mailto:[EMAIL PROTECTED]
> Tel: 0141 575 9700
> Fax: 0141 575 9600
>
> Creative solutions in a technical world
>
> ----------------------------------------------------------------------
> Get your domain names online from:
> http://www.alienationdomains.co.uk
> Reseller options available!
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
>
>
>
> "Damian Watson"
> <[EMAIL PROTECTED] To:
<[EMAIL PROTECTED]>
> ign.co.uk> cc:
> Subject: Re: [
cf-dev ] percentages of values in recordset
> 11/06/2003 15:36
> Please respond to dev
>
>
>
>
>
> Thanks Rich, don't think I explained myself very well though. What I'm
> trying to do is:
>
> SELECT myValue, COUNT(myValue) AS Whatever
> FROM myTable
> Where myValue=1 (and then on up to 5)
>
> Then output the count as a percentage of the whole recordcount.
>
> I realise I could loop it from 1 to 5 but myValue is already being looped
> and I'm going to end up with a silly amount of queries generated
>
> Cheers
> d
>
> ----- Original Message -----
> From: "Rich Wild" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, June 11, 2003 3:12 PM
> Subject: RE: [ cf-dev ] percentages of values in recordset
>
>
> > SELECT myValue, COUNT(myValue)
> > FROM myTable
> > GROUP BY myValue
> >
> > > -----Original Message-----
> > > From: Damian Watson [mailto:[EMAIL PROTECTED]
> > > Sent: 11 June 2003 15:21
> > > To: [EMAIL PROTECTED]
> > > Subject: [ cf-dev ] percentages of values in recordset
> > >
> > >
> > > Hi,
> > >
> > > Pretty dumbass question but I'm working on a poll where for
> > > instance I have
> > > a column with 5 possible values (1 to 5).
> > >
> > > Say there are 50 records. How do I get the number of records
> > > for each value
> > > without doing 5 queries?
> > >
> > > Cheers
> > > d
> > >
> > >
> > >
> > > --
> > > ** Archive:
http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
> > >
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > For human help, e-mail: [EMAIL PROTECTED]
> > >
> >
> >
> > --
> > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
> >
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > For human help, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
>
>
>
>
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
