Thanks!
IROSE
> -----Original Message-----
> From: Jim McAtee [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 24, 2001 2:59 PM
> To: CF-Server
> Subject: Re: Limitations of CFPROCPARAM
>
> Try using the DBVARNAME parameter in your CFPROCPARAM tags with the same
> variable names being used as parameters within the stored procedure.
>
> Jim
>
>
> ----- Original Message -----
> From: "Rose, Israel" <[EMAIL PROTECTED]>
> To: "CF-Server" <[EMAIL PROTECTED]>
> Sent: Monday, September 24, 2001 12:29 PM
> Subject: RE: Limitations of CFPROCPARAM
>
>
> > <CFSTOREDPROC Procedure="Tally_Data.Summate" datasource="mydatasource"
> > username="myusername" password="mypassword" RETURNCODE="Yes">
> > <CFPROCPARAM Type="IN" CFSQLTYPE="CF_SQL_INTEGER" VALUE=#Surv_Number#>
> > <CFPROCPARAM Type="IN" CFSQLTYPE="CF_SQL_CHAR" VALUE=#X#>
> > </CFSTOREDPROC>
> > <CFSET Elem_Per = CFSTOREDPROC.STATUSCODE>
> >
> > As I stated, this works with the CF_SQL_CHAR type hard-coded in the proc
> and
> > sending in the Integer type alone; or I can encode the char as an
> integer
> > and decode it within the proc but it will only take a single procparam
> in
> > either case. Thanks for your help.
> >
> > IROSE
> >
> > > -----Original Message-----
> > > From: Mark Stewart [SMTP:[EMAIL PROTECTED]]
> > > Sent: Monday, September 24, 2001 11:18 AM
> > > To: CF-Server
> > > Subject: RE: Limitations of CFPROCPARAM
> > >
> > > You aren't limited. Or, I should say, I've never run into this problem
> > > before. I run my stored procs on SQL Server and I pass many params of
> > > varying types. It might help if you showed me what your proc looks
> like.
> > > That is, show the cf code that calls the stored proc. I'm assuming
> > > you've checked to make sure your not using any Oracle reserved words,
> > > etc.
> > >
> > > Mark
> > >
> > > -----Original Message-----
> > > From: Rose, Israel [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, September 24, 2001 10:13 AM
> > > To: CF-Server
> > > Subject: Limitations of CFPROCPARAM
> > >
> > >
> > > Can anyone tell me why I am limited to use of only one CFPROCPARAM
> upon
> > > calling a CFSTORED PROC?
> > >
> > > I get the following message if I use the Stored Proc with either a
> > > non-numeric Proc Param or more than one Proc Param as an attribute.
> Any
> > > insights?
> > >
> > >
> > > Error Diagnostic Information
> > >
> > > Oracle Error Code = 1036
> > >
> > > ORA-01036: illegal variable name/number
> > >
> > > SQL = "Tally_Data.Summate"
> > >
> > > Data Source = "insited"
> > >
> > > The error occurred while processing an element with a general
> > > identifier of
> > > (CFSTOREDPROC), occupying document position (82:1) to (82:117) in the
> > > template file
> > > F:\htdocs\material\sw_supplier_rating\Tally_Temp_Data.cfm.
> > >
> > >
> > >
> > >
> > > IROSE
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
