ok -- I really have confused things! Maybe it's the way I've asked the
question. I have a solution though that at least saves me querying lots,
it'll help you see what I'm doing.
<cfparam name="Value1" default=0>
...same for 2,3,4,5
<cfquery name="QueryName">
SELECT ColumnName, COUNT(ColumnName) AS Count
FROM TableName
</cfquery>
<cfloop query="QueryName">
<cfif ColumnName EQ 1>
<cfset Value1=Value1 + 1>
<cfelseif ColumnName EQ 2>
<cfset Value2=Value2 + 1>
etc etc...
</cfif>
</cfloop>
Then to get the percentage:
<cfoutput query="QueryName">#DecimalFormat(Evaluate((Value1 / Count) *
100))# %</cfoutput>
Apologies if I'm being stoopid ;0)
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 3:55 PM
Subject: Re: [ cf-dev ] percentages of values in recordset
>
> 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]
>
--
** 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]
