RE: data in columns

2001-01-19 Thread Jann VanOver
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

RE: data in columns

2001-01-19 Thread Robert Orlini
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

RE: data in columns

2001-01-19 Thread Hayes, David
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

RE: data in columns

2001-01-19 Thread Katrina Chapman
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

RE: data in columns

2001-01-19 Thread Katrina Chapman
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

Re: data in columns

2001-01-18 Thread Nathan Chen
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

Re: data in columns

2001-01-18 Thread C Frederic Valone
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

RE: data in columns

2001-01-18 Thread Christopher Olive, CIO
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

RE: data in columns

2001-01-18 Thread Mike Townend
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

data in columns

2001-01-18 Thread Robert Orlini
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 #