Use HAVING in your SQL:
SELECT state, COUNT (state) AS StateCount
FROM Wobinfo
GROUP BY state
HAVING COUNT(state) > 1
ORDER BY COUNT(state)
-----Original Message-----
From: Ann Harrell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 11:31 AM
To: CF-Talk
Subject: Access and CFGraph
I have this query that goes through the database and counts up the number of
people from each state and then I put it in a cfgraph. How do I get it to
only display states that are greater than 1?
SELECT state, COUNT (state) AS StateCount
FROM Wobinfo
GROUP BY state
ORDER BY COUNT(state)
<CFGRAPH TYPE="BAR"
QUERY="GetStates"
VALUECOLUMN="StateCount"
ITEMCOLUMN="State"
SHOWVALUELABEL="Yes"
VALUELOCATION="ONBAR"
SCALEFROM="0"
SCALETO="10"
TITLE="Wobbers By State"
FILEFORMAT="Flash"
GRAPHHEIGHT="500"
GRAPHWIDTH="700"
BACKGROUNDCOLOR="white"
DEPTH="10"
COLORLIST="red,green,blue,yellow,orange, fuchsia, teal, Lime"
GRIDLINES="4">
</cfgraph>
Ann Harrell
Harrell Computer Enterprises
Phone: 219.342.0618
eFax: 603.843.9212
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
