Railo 3.3.5.004 Error (database)
Message The value is not set for the parameter number 1.
SQL
select
vehicletypekey
from vehiclecore (nolock)
where vehiclekey = [CF_SQL_INTEGER]
DatabaseName Microsoft SQL Server
DatabaseVersion 10.00.5500
DriverName Microsoft SQL Server JDBC Driver 3.0
DriverVersion 3.0.1301.101
Datasource powerlinks
Stacktrace The Error Occurred in
C:\Inetpub\wwwroot\com\webmalls\Vehicles.cfc: line 298
296: vehicletypekey
297: from vehiclecore (nolock)
298: where vehiclekey = <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.vehiclekey#">
299: </cfquery>
300:

called fromC:\Inetpub\wwwroot\webmallDetails.cfm: line 19
called fromC:\Inetpub\wwwroot\application.cfc: line 145
Java Stacktrace The value is not set for the parameter number 1.
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171):171
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.buildParamTypeDefinitions(SQLServerPreparedStatement.java:262):262
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.buildPreparedStrings(SQLServerPreparedStatement.java:221):221
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doPrepExec(SQLServerPreparedStatement.java:598):598
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:386):386
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340):340
   at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575):4575
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400):1400
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179):179
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154):154
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322):322
   at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:231):231
   at railo.runtime.tag.Query.executeDatasoure(Query.java:622):622
   at railo.runtime.tag.Query.doEndTag(Query.java:474):474
   at com.webmalls.vehicles_cfc$cf._1(C:\Inetpub\wwwroot\com\webmalls\Vehicles.cfc:298):298
   at com.webmalls.vehicles_cfc$cf.udfCall(C:\Inetpub\wwwroot\com\webmalls\Vehicles.cfc):-1
   at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215
   at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434
   at railo.runtime.type.UDFImpl.call(UDFImpl.java:384):384
   at railo.runtime.ComponentImpl._call(ComponentImpl.java:615):615
   at railo.runtime.ComponentImpl._call(ComponentImpl.java:502):502
   at railo.runtime.ComponentImpl.call(ComponentImpl.java:1815):1815
   at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733
   at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1480):1480
   at webmalldetails_cfm$cf.call(C:\Inetpub\wwwroot\webmallDetails.cfm:19):19
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:799):799
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:746):746
   at application_cfc$cf.udfCall(C:\Inetpub\wwwroot\application.cfc:145):145
   at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215
   at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434
   at railo.runtime.type.UDFImpl.call(UDFImpl.java:384):384
   at railo.runtime.ComponentImpl._call(ComponentImpl.java:615):615
   at railo.runtime.ComponentImpl._call(ComponentImpl.java:502):502
   at railo.runtime.ComponentImpl.call(ComponentImpl.java:1815):1815
   at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:349):349
   at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:106):106
   at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23
   at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2035):2035
   at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2002):2002
   at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297
   at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722):722
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225):225
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169):169
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472):472
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168):168
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98):98
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407):407
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999):999
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565):565
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307):307
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source):-1
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1
   at java.lang.Thread.run(Unknown Source):-1