Try using SELECT * and see if that works, if so then take a hard look at the
field names. Try adding WHERE 0 = 0 and see if that does anything
different. Also, make sure #request.dsn# has the proper value and is
looking up the right table.
Joby Bednar
Director of Internet Design
iNEOgroup.com
-----Original Message-----
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 8:54 AM
To: CF-Talk
Subject: Driving Me Nuts
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
