Question
No Resulsts from CFC calling MSSQL Procedure
I'm calling a stored procedure within a CFC. I'm getting this
error:
Procedure 'sp_AddCustomer' expects parameter '@newKey', which was not supplied.
<cfstoredproc datasource="#ARGUMENTS.dsn#" procedure="sp_AddCustomer">
<cfprocparam type="in" value="#FORM.donorid#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.email#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.homephone#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.workphone#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.cellphone#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.lastname#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.firstname#" cfsqltype="cf_sql_varchar">
<cfprocresult name="newKey">
</cfstoredproc>
Here is the stored procedure
CREATE PROCEDURE dbo.sp_AddCustomer
@custnum varchar(20)
,@email varchar(50)
,@homephone varchar(30)
,@workphone varchar(30)
,@cellphone varchar(30)
,@lastname varchar(50)
,@firstname varchar(50)
,@newKey int OUTPUT
AS
Insert Into tblcustomer(custnum
,email
,homephone
,workphone
,cellphone
,lastname
,firstname)
Values(@custnum
,@email
,@homephone
,@workphone
,@cellphone
,@lastname
,@firstname)
Select @newKey = scope_identity();
GO
Procedure 'sp_AddCustomer' expects parameter '@newKey', which was not supplied.
<cfstoredproc datasource="#ARGUMENTS.dsn#" procedure="sp_AddCustomer">
<cfprocparam type="in" value="#FORM.donorid#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.email#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.homephone#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.workphone#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.cellphone#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.lastname#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#FORM.firstname#" cfsqltype="cf_sql_varchar">
<cfprocresult name="newKey">
</cfstoredproc>
Here is the stored procedure
CREATE PROCEDURE dbo.sp_AddCustomer
@custnum varchar(20)
,@email varchar(50)
,@homephone varchar(30)
,@workphone varchar(30)
,@cellphone varchar(30)
,@lastname varchar(50)
,@firstname varchar(50)
,@newKey int OUTPUT
AS
Insert Into tblcustomer(custnum
,homephone
,workphone
,cellphone
,lastname
,firstname)
Values(@custnum
,@homephone
,@workphone
,@cellphone
,@lastname
,@firstname)
Select @newKey = scope_identity();
GO