Use the Database to do the hard part:
SELECT count(cbi) as cbicount
FROM wweb
Where cbi like 'CBI'
#wweb.cbiCount#
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 7:48 AM
To: CF-Talk
Subject: data in columns
H
Thanks for everyone's feedback on this! I got it going w/the "Select Count".
Robert O.
>-Original Message-
>From: Hayes, David [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, January 18, 2001 2:22 PM
>To: CF-Talk
>Subject: RE: data in columns
>
>
>1
rlini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 9:48 AM
To: CF-Talk
Subject: data in columns
Hello,
I'm still a newbie with this one though I've tried. How can I count data in
certain columns of a table for each record. Some records have no data in
this field of the colum
CF-Talk
Subject: RE: data in columns
you could just try the count(*) operator.
SELECT count(*) as thecount
FROM wweb
Where
cbi like 'CBI' AND cbi IS NOT NULL
this will give you a variabel queryname.thecount where cbi is equal to 'CBI'
and cbi is not null.
chr
w.katrinachapman.com
http://www.cfchick.com
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 3:48 PM
To: CF-Talk
Subject: data in columns
Hello,
I'm still a newbie with this one though I've tried. How can I count data in
certa
First, try using where cbi like 'CBI%'
Second, you can just use #Get.recordcount# to return the number of records you query
finds.
--Nathan
Robert Orlini wrote:
> Hello,
>
> I'm still a newbie with this one though I've tried. How can I count data in
> certain columns of a table for each rec
If you are already selecting only the rows where cbi like 'CBI' then you will not get
any of the rows where cbi is empty so you
could just use the variable get.recordcount to get a count of rows.
PS
You cannot to my knowledge use the cf set as you have there referencing a column in
the query
ies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 10:48 AM
To: CF-Talk
Subject: data in columns
Hello,
I'm still a newbie with this one though I've tried. How can I count data in
o: CF-Talk
Subject: data in columns
Hello,
I'm still a newbie with this one though I've tried. How can I count data in
certain columns of a table for each record. Some records have no data in
this field of the column so of course I don't want that counted. I kept it
VERY VERY
Hello,
I'm still a newbie with this one though I've tried. How can I count data in
certain columns of a table for each record. Some records have no data in
this field of the column so of course I don't want that counted. I kept it
VERY VERY simple below. I've tried different configurations, but #
10 matches
Mail list logo