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) Pull the <cfset> out of the <cfquery> block
>
>2) You are searching on LIKE 'CBI', but testing on EQ 'CBI'; are you sure
>about the values?
>
>3) Select count(cbi) as cbicount
> from wweb
> where cbi = 'CBI'
>
>
>-----Original Message-----
>From: Robert Orlini [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 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
