Having a hugs CFSTOREDPROC problem … do I submit it here?  Tried to before but got an error. 

This is my Cfstoredproc:

<cfstoredproc datasource=”#application.dsn#” procedure=”upMidTempIDAdd”>

<cfprocparam type=”In” cfsqltype=”CF_SQL_INTEGER” dbvarname=”@acbd” value=”7″>
<cfprocparam type=”Out” cfsqltype=”CF_SQL_INTEGER” dbvarname=”@new_temp_id” variable=”new_id”>

</cfstoredproc>

This is the proc

ALTER PROCEDURE [dbo].[upMidTempIDAdd]

@abcd int,
@new_temp_id int out
as

insert into memberResTempID
(drama)
values(@abcd)

set @new_temp_id = @@identity

GO

This is my table (cannot upload???)

This is my error: