Coldfusion MX 7 Parameter index out of range (2 > number of parameters, which is 1).
Posted by: Morris Campbell
Date: July 03, 2008 06:48PM

Stored Procedure:

CREATE PROCEDURE sp(MM INT)
BEGIN
Select DayOfWeek(AppointmentDate) Appointments,
TruckOne_1000,
TruckOne_1000_ZipCode
FROM appointment
WHERE
DayOfWeek(AppointmentDate) = MM;
END

Coldfusion Code:

<cfstoredproc procedure="sp" datasource="#Request.MainDSN#">
<cfprocparam value="2" cfsqltype="cf_sql_integer">
<cfprocresult name="dataresults" resultset="1">
</cfstoredproc>

Calling the stored procedure from the MySQL console works fine, but when executing the stored procedure from Coldfusion the following error is returned:

Error Executing Database Query.
Parameter index out of range (2 > number of parameters, which is 1).

The error occurred in C:\CFusionMX7\wwwroot\CleanACarpet Flash\StoredProcTest.cfm: line 15

13 : <cfprocparam value="2" cfsqltype="cf_sql_integer">
14 :
15 : <cfprocresult name="AppointmentData" resultset="1">
16 :
17 :


--------------------------------------------------------------------------------

SQL { (param 1) = call sp( (param 2) )}
DATASOURCE nexcyte
SQLSTATE S1009

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Remote Address 127.0.0.1
Referrer
Date/Time 03-Jul-08 08:40 PM

Stack Trace (click to expand)
at cfStoredProcTest2ecfm700908298.runPage(C:\CFusionMX7\wwwroot\CleanACarpet Flash\StoredProcTest.cfm:15) at cfStoredProcTest2ecfm700908298.runPage(C:\CFusionMX7\wwwroot\CleanACarpet Flash\StoredProcTest.cfm:15)


java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2242)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2268)
at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:2226)
at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:2512)
at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:2403)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.setObject(JRunPreparedStatement.java:208)
at coldfusion.sql.InParameter.setStatement(InParameter.java:58)
at coldfusion.sql.ParameterList.setStatement(ParameterList.java:107)
at coldfusion.sql.Executive.executeCall(Executive.java:561)
at coldfusion.sql.Executive.executeCall(Executive.java:517)
at coldfusion.sql.Executive.executeCall(Executive.java:477)
at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:320)
at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:193)
at cfStoredProcTest2ecfm700908298.runPage(C:\CFusionMX7\wwwroot\CleanACarpet Flash\StoredProcTest.cfm:15)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:50)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:349)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:457)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:295)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Options: ReplyQuote


Subject
Written By
Posted
Coldfusion MX 7 Parameter index out of range (2 > number of parameters, which is 1).
July 03, 2008 06:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.