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 from within the cfquery tag.
Hope that helps,
Frederic
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 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
