Ann Harrell
|
Posted: 07/26/2001, 3:10 PM |
|
I was able to get my Coldfusion graph to work using this code. Unfortunaetly
when I generate the code it puts a CFLoop and goes through the query for
each state with a count, twenty of them. I get 20 different Flash graphs on
the page. By editing and taking out the cfloop code in the generated
template it works properly.
What sets the code to loop through a query so I can uncheck it?
Ann Harrell
Form Properties/SQL:
SELECT state, COUNT (state) AS StateCount
FROM Wobinfo
GROUP BY state
Order by COUNT(state)
Form Properties/Events/Before Show
<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>
|
|
|
|