(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]
