You have to specify the sort order.
ORDER BY FormDescrip ASC
That's all it is. Caught me on that one once too.
Stuart Duncan
MaracasMedia Inc.
At 10:53 AM 1/30/01 -0600, you wrote:
>I have a query running fine on my local server, but it won't execute
>properly on the remote server. It's very simple:
>
><cfquery name="GetFormInfo" datasource="#request.dsn#">
>SELECT FormID, FormName, FormDescrip
>FROM Forms
>ORDER BY FormDescrip
></cfquery>
>
>The error:
>"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."
>
>Any ideas? This is driving me crazy. Running Access 2000.
>
>Chris Montgomery [EMAIL PROTECTED]
>
>Web Development & Consulting http://www.astutia.com
>Allaire Consulting Partner
>210-490-3249/888-745-7603 Fax 210-490-4692
>AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
