I dunno personally -- you should ask the Railo list. Looks like a similar issue here:
https://groups.google.com/forum/?fromgroups#!topic/railo/25RLQV2cPls And here: http://critterscode.com/2011/02/25/railo-doesnt-like-stored-procedures/ David Kanter said the following on 04/12/2011 01:24 AM: > Vince, > > Do you know if this is an issue for Railo as well? > > David > > On Apr 10, 7:41 am, Vince Bonfanti <[email protected]> wrote: >> The Microsoft JDBC driver doesn't like the "@" when you specify the >> DBVARNAME attribute in the CFPROCPARAM tag. Remove the "@" and just specify >> DBVARNAME="id" and it will work. >> >> On Sat, Apr 9, 2011 at 8:55 PM, David Kanter <[email protected]> wrote: >>> Happy to share code: >>> I get a General SQL Error with the following message: "Parameter @id >>> was not defined for stored procedure rwtadmin.xcursus_getthread." THe >>> SQL State is S1093. >>> The rwtadmin.xcursus_getthread procedure takes as input: >>> @id INT >>> @threadid INT >>> @roomid TINYINT >>> @showfullthread BIT=0 >>> @hideflaggedposts BIT=0 >>> @nextprev INT >>> It is called in the following context: >>> <cfinclude template="functions.cfm"> >>> <cfif isdefined("url.entryid")><cfset url.id = url.entryid></cfif> >>> <cfparam name="url.id" type="numeric"> >>> <cfparam name="url.threadid" type="numeric"> >>> ...irrelevant code snipped >>> <cfstoredproc procedure="rwtadmin.xcursus_getthread" >>> datasource="#request.ds#" returncode="yes"> >>> <cfprocparam type="in" value="#url.id#" >>> cfsqltype="CF_SQL_INTEGER" null="No" dbvarname="@id"> >>> <cfprocparam type="in" value="#url.threadid#" >>> cfsqltype="CF_SQL_INTEGER" null="No" dbvarname="@threadid"> >>> <cfprocparam type="in" value="#url.roomid#" >>> cfsqltype="CF_SQL_INTEGER" null="No" dbvarname="@roomid"> >>> <cfprocparam type="in" value="#session.forumsettings.showthread#" >>> cfsqltype="CF_SQL_BIT" null="No" dbvarname="@showfullthread"> >>> <cfprocparam type="in" value="#hideflaggedposts#" >>> cfsqltype="CF_SQL_BIT" null="No" dbvarname="@hideflaggedposts"> >>> ...irrelevant code snipped >>> <cfprocresult name="detail" resultset="1"> >>> <cfprocresult name="posts" resultset="2"> >>> </cfstoredproc> >>> Like I said, it works perfect in production, but sure not on my dev >>> system. >>> David >> -- Peter J. Farrell [email protected] [email protected] http://blog.maestropublishing.com Identi.ca / Twitter: @maestrofjp -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
