CFProc vs CFQuery

[Andrew Spear]

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]

---