: 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
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
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
]
ign.co.ukcc:
Subject: Re: [ cf-dev ]
percentages of values in recordset
11/06/2003 15:36
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
of each one from the count column and
arraysum(listtoarray(valuelist(myQuery.countIDcolumn)))
-Original Message-
From: Damian Watson [mailto:[EMAIL PROTECTED]
Sent: 11 June 2003 15:46
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] percentages of values in recordset
That bit's easy
:
Subject: Re: [ cf-dev ]
percentages of values in recordset
11/06/2003 15:45
Please respond to dev
]
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
PROTECTED]
Subject: Re: [ cf-dev ] percentages of values in recordset
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
((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
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,
Ah ok... beginner's SQL course for me.
Thanks everyone.
d
- Original Message -
From: Stephen Moretti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 5:03 PM
Subject: Re: [ cf-dev ] percentages of values in recordset
ok -- I really have confused things! Maybe
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
13 matches
Mail list logo