check out the book that Justin mentioned in this thread, you'll learn how to take loads of weight off that poor straining CF server of yours onto the database, which is built to do such things more efficiently! :D
> -----Original Message----- > From: Ian Westbrook [mailto:[EMAIL PROTECTED] > Sent: 11 June 2003 15:29 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] percentages of values in recordset > > > 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] -- ** 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]
