cfstored proc returning value

[Tangorre, Michael]

Anyone see whats wrong with the following stored procedure call, I keep getting the following error when trying to return an integer (last ID)...


"Invalid data  for CFSQLTYPE CF_SQL_INTEGER."


CF Stored Proc Call....


<cfstoredproc
  procedure="INSERT_COMMUNITY_BUSINESS"
  datasource="#application['stcGlobalVars']['dsn_insert']#">
  
  <cfprocparam
   cfsqltype="CF_SQL_INTEGER"
   value="#Trim(attributes['businessType'])#"
   null="#YesNoFormat(Trim(attributes['businessType']) EQ 0)#" />
   
  <cfprocparam
   cfsqltype="CF_SQL_VARCHAR"
   value="#Trim(attributes['businessName'])#"
   null="no" />
   
  <cfprocparam
   cfsqltype="CF_SQL_VARCHAR"
   value="#Trim(attributes['division'])#"
   null="#YesNoFormat(Len(Trim(attributes['division'])) EQ 0)#" />
  
  <cfprocparam
   cfsqltype="CF_SQL_INTEGER"
   type="Out"
   variable="newId" />
   
</cfstoredproc>


And the T-SQL stored proc...


CREATE PROCEDURE INSERT_COMMUNITY_BUSINESS

@VAR_BUSINESS_TYPE_ID INT,
@VAR_BUSINESS_NAME VARCHAR(50),
@VAR_BUSINESS_DIVISION VARCHAR(50),
@VAR_NEW_ID INT OUTPUT


AS

INSERT INTO
COMMUNITY_BUSINESS
(
BUSINESS_TYPE_ID,
BUSINESS_NAME,
BUSINESS_DIVISION
)
VALUES
(
@VAR_BUSINESS_TYPE_ID,
@VAR_BUSINESS_NAME,
@VAR_BUSINESS_DIVISION
)


SELECT @VAR_NEW_ID = SCOPE_IDENTITY()


GO


Thanks!


Mike

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---