that's bloody useful, Rich, thanks for that. I too have been wondering for a while how to do it.
ianwest ----- 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]
