On 1/30/01, Chris Montgomery penned:
>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)
You're 100% positive you have:
A: The exact same database on each server and that you haven't
changed a name of, or added a table or column in the database on the
local machine?
B: Wherever you set request.dsn it is pointing to the correct database?
C: Have the correct template file uploaded?
If so, then I'm stumped.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
