You could turn this into a GROUP BY query
cfquery name="Getastindex" datasource="wweb"
SELECT COUNT(ast) AS ast_count, ast
FROM wweb
GROUP BY ast
ORDER BY ast
/cfquery
Then, your results set would be something like:
ast ast_count
SELECTast, 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
e 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
SELECTast, count(ast) AS counter
FROM wweb
WHERE ast IN ('ASTIndex', 'ASTAI', 'ASTft')
GROUP BY ast
Yo
3 matches
Mail list logo