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.
chris olive, cio
cresco technologies
[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
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 #cbicount#
always returns a blank.
Any help is always appreciated. Thank you.
Robert O.
----------------------------------
Below I'm trying to count how many times CBI appears in the cbi column and
display the total tally in the #cbicount# variable:
<cfquery name="Get" datasource="wweb">
SELECT id, cbi
FROM wweb
Where cbi like 'CBI'
<cfif cbi EQ "CBI">
<cfset cbicount + 1>
</cfif>
</cfquery>
<CFOUTPUT>
#cbiCount#
</CFOUTPUT>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
