Question
Stored Procedure Call from CFMX7
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. The procedure is on SQL Server 2000.
Here is my call:
<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.
Here is my call:
<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.