Thanks Raymond.
Am I right in figuring the code you emailed searches for an occurrence of
"AST" in the "ASTIndex", "ASTAI", and "ASTFT" columns?
I should have explained it's the other way around; I'm searching for
"ASTIndex", "ASTAI", and "ASTFT" in the "AST" column and then doing a
separate count for each of those three texts.
In displaying the count with: <CFOUTPUT QUERY="GetAsT">#counter#</CFOUTPUT>
I'm also stumped. How do I get each separate count to display with
<cfoutput>?
Thanks again for the anticipated help.
Robert O.
>-----Original Message-----
>From: Raymond B. [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, January 31, 2001 3:42 PM
>To: CF-Talk
>Subject: RE: faster count
>
>
>SELECT ast, count(ast) AS counter
>FROM wweb
>WHERE ast IN ('ASTIndex', 'ASTAI', 'ASTft')
>GROUP BY ast
>
>You're using LIKE improperly here as it's useless w/o a wildcard (%) char;
>just use = if you want a direct match. If you do need the wildcard
>use a ast
>LIKE '%foo%' OR ast LIKE '%bar' instead of the IN().
>
>-----Original Message-----
>From: Robert Orlini [mailto:[EMAIL PROTECTED]]
>Sent: January 31, 2001 16:53
>To: CF-Talk
>Subject: faster count
>
>
>Hello,
>
>I have an Access table that I need to get a count for a specific value in
>each column. The coding below does the trick (on one column), but is too
>slow since I have numerous columns. I'm kinda a newbie on this so I was
>wondering is there away to make the count quicker by combining some of the
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
