Procedure or function has too many arguments specified.

i getting error when add parameter cold fusion program , stored procedure. if take comments out, error.

 

what doing wrong?

 

this coldfusion part.

 

      <cfset service='test'>
      <cfset units=12.34>
      <cfset date1='12/25/08'>
      <cfset recid=100>

      <cfstoredproc procedure="try2" datasource="#dso#">
<!---         <cfprocparam cfsqltype="cf_sql_char" value="#served#"> --->
         <cfprocparam cfsqltype="cf_sql_float" value="#units#">
         <cfprocparam cfsqltype="cf_sql_datetime" value="#date1#">
         <cfprocparam cfsqltype="cf_sql_numeric" value="#recid#">
         <cfprocparam cfsqltype="cf_sql_numeric" type="out" variable="recs">
      </cfstoredproc>

sql server part.

 

 

 

 

 

 

 

 

 

 

 

set

 

ansi_nulls on

set

 

quoted_identifier on

go

alter

 

procedure [dbo].[try2]

(

-- @arg_served char,

@arg_units

decimal(6,2),

@arg_date1

datetime,

@arg_recid

numeric,

@arg_id2

int out

)

as

begin

 

 

set nocount on;

 

 

update table1 set units=@arg_units, date1=@arg_date1 where recid=@arg_recid;

 

 

select @arg_id2=@@rowcount;

end

 

the first thing jumps out cf variable called "service" , cfprocparam called "served". think real issue @arg_served char 1 character in length need add length such @arg_served char(10) pass in value of "test".

More discussions in ColdFusion

adobe