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]