cfprocparam is ignored (there's no specification in the ODBC standard
for calling parameters by name unfortunately). Two things you might
want to try: change the datasource in cfadmin to use the ODBC Socket
or move the procresult tag down below your procparam tags (I don't
expect that to change anything, but you never know till you try).
> I'm running into a weird error using CFProc and I'm
> clueless as to why it just stopped working. I started
> receiving "Value can not be converted to requested type."
> error when running the CFProc tag. Nothing seemed to
> solve it until I called the same Stored Proc using CFQuery
> instead. I'm using MX 6.1 and SQL 2000.
> Here's the stored proc
> <cfstoredproc procedure="pr_getApprover"
> datasource="#g_DSN#">
> <cfprocresult name="getApproverqry">
> <cfprocparam cfsqltype="CF_SQL_INTEGER"
> dbvarname="@WorkFlowEntryID" value="7">
> <cfprocparam cfsqltype="CF_SQL_INTEGER"
> dbvarname="@RequestID" value="1">
> <cfprocparam cfsqltype="CF_SQL_INTEGER"
> dbvarname="@ProgramID" value="0">
> </cfstoredproc>
> and here's the CFQuery...
> <cfquery name="getApproverqry" datasource="#DSN#">
> {call pr_getApprover(7,1,0)}
> </cfquery>
> Seems to point to the JDBC driver and how CF calls procs
> using the CFProc tag. But I'm stumped...
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
