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
On Apr 9, 3:21 pm, "Peter J. Farrell" <[email protected]> wrote:
> ACF uses the commercial DataDirect drivers while OpenBD uses the open
> source JTDS drivers.
>
> What errors are you seeing? Can you share some code as well and explain
> what the differences are.
>
> .pjf
>
> David Kanter said the following on 04/09/2011 05:15 PM:
>
>
>
> > In the process of getting a development version of my website up, I
> > ran into a very strange problem with BD/SQL Server. What's unusual is
> > that it doesn't happen in the production instance of my site, which
> > runs with Adobe CF/SQL Server.
>
> > Our cold fusion isn't using any tags that are problematic in terms of
> > compatibility, so I'm somewhat puzzled about the different results for
> > the different systems. In theory, everything should work equally well
> > under the two CFML engines.
>
> > So I am wondering if the Adobe CFML engine has a slightly different
> > database connector from OpenBD. Matt Woodward had a blog post
> > indicating this was an issue for Oracle (http://blog.mattwoodward.com/?
> > tag=tomcat). Some sort of issue with the connector could at least
> > explain why SQL Server is complaining about the parameters we are
> > supplying under OpenBD, but not Adobe CF.
>
> > Any thoughts?
>
> > 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
