The following produces the error:

<cfquery name="..." datasource="...">   
   EXEC SELECT_ABACUS_POINT_OF_CONTACT_DETAIL
      <cfqueryparam
   cfsqltype="CF_SQL_INTEGER"
   value="#attributes['intPocId']#"
   null="No" />
</cfquery>

However this does work:

<cfstoredproc
   procedure="SELECT_ABACUS_POINT_OF_CONTACT_DETAIL"
   datasource="...">

   <cfprocparam
      cfsqltype="CF_SQL_INTEGER"
value="#attributes['intPocId']#"
null="No" />

   <cfprocresult
      name="selectAbacusPocDetail"
resultset="1">

</cfstoredproc>

The only difference was the style in which the procedure was called. Now, I
shortened the name of the procedure and both ways worked. Guess my need to
eb descrpitive in my naming is gonna sting me in the ass if this holds true!

Mike



> Anyone seen this?
>  
> TYPE: java.lang.ArrayIndexOutOfBoundsException
> MESSAGE: 6>=6
>  
> Just started popping up...
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to