Skip to main content
C
casegama
Inspiring
March 2, 2010
Question

"Too few parameters" error one remote server - works fine locally

  • March 2, 2010
  • 1 reply
  • 814 views

When testing locally, everything seems to be working fine but I'm getting the following error upon upload to the remote server.

I'm using CF with MS Access and the rest of the my files pulling from other tables in the the same Access db are working fine both locally and remotely.  Any ideas?

thank you,

Luis

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

The error occurred in C:\Websites\rc2f7cae\admin\CoolCases\index2.cfm: line 13
11 :   <cflocation url="#MM_failureURL#" addtoken="no">
12 : </cfif>
13 : <cfquery name="rsCoolCases" datasource="#Request.DSN#">
14 : SELECT cases_ID, patient, "online"
15 : FROM coolcases
This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
March 2, 2010

Double quotes are bad when using odbc.  When you say local testing, do you mean just in access, or with coldfusion?

Also, when you select a constant and don't give it an alias, it won't be accessible later.

C
casegamaAuthor
Inspiring
March 2, 2010

Still getting the same error with single quotes and without quotes.

Luis

C
casegamaAuthor
Inspiring
March 3, 2010

troubleshooting 101, do one thing at a time until it crashes.

Start with

SELECT cases_ID

<---, patient

, "online"
--->

FROM coolcases

if it runs successfully, uncomment the patient line.  If that runs successfully, uncomment the online line.  See what line causes the problem.

The online line with double quotes should always crash.


Problem seems to be with cases_id, but still can't identify the exact cause.

cases_id is my primary key in my table and an autonumber, but the entire table is set up exactly like my others that seem to be working fine both locally and remotely.

<cfquery name="rsCool" datasource="#Request.DSN#">
SELECT Cases_ID, Patient, Online
FROM Coolcases
ORDER BY Patient ASC
</cfquery>

When I substitute a * for my db fields, I get a different error related to Cases_ID later in the page from an anchor with a parameter.

<a href="edit.cfm?TypeID=#rsCool.TypeID#">#rsCool.Patient#</a>

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices