Stored Procedure call from CFMX

Colonel Angus · September 20th, 2006, 08:27 AM

I have a stored procedure that returns properly when run from ColdFusion 5, but not ColdFusion MX. Under MX, it returns an empty string. The execution of the procedure by itself works as it should, but for some reason I can't get it to execute right under MX.

Here is my call:

Code:

<CFSTOREDPROC procedure="x3ed" 
    datasource="centersdb" 
    debug="yes" 
    returncode="yes">
    <CFPROCPARAM type = "IN"
    cfsqltype="CF_SQL_VARCHAR"
    value="E"> 
    <CFPROCPARAM type = "IN"
        cfsqltype="CF_SQL_VARCHAR"
    value=#form.password#>
    <cfprocparam type = "OUT" 
    cfsqltype="CF_SQL_VARCHAR"
    variable = "encpwd">
</cfstoredproc>

Any ideas? I wasn't able to find any deprecated attributes that I am using. Thanks in advance for your help.

-- Colonel