That works! Thanks!
> -----Original Message-----
> From: tmwall [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 05, 2001 11:59 PM
> To: CF-Talk
> Subject: RE: Order by: Access 2000 Question
>
>
> 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
