Ann,
Try
SELECT state, COUNT (state) AS StateCount
FROM Wobinfo
GROUP BY state
Order by COUNT(state)
-----Original Message-----
From: Ann Harrell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 10:57 PM
To: CF-Talk
Subject: Order by: Access 2000 Question
I have a graph that uses a Access 2000 query. You can see it at the link. It
won't let me ORDER BY StateCount
Here is the error if I add Order by Statecount after group by:
Error Diagnostic Information
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the fields
included in your query exist and that you have specified their names
correctly.
SQL = "SELECT state, COUNT (state) AS StateCount FROM Wobinfo GROUP BY state
Order by StateCount"
Data Source = "WOBBERSMET"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:50) in the template file
C:\INETPUB\WWWROOT\WOB\STATEDATA.CFM.
http://ann.bourbon.hoosierlink.net/Wob/StateData.cfm
<cfquery name="GetStates" datasource="WobbersMet">
SELECT state, COUNT (state) AS StateCount
FROM Wobinfo
GROUP BY state
</cfquery>
<CFGRAPH TYPE="BAR"
QUERY="GetStates"
VALUECOLUMN="StateCount"
ITEMCOLUMN="State"
SHOWVALUELABEL="Yes"
VALUELOCATION="ON BAR"
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>
</body>
</html>
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
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
