could it be because 'DESC' is a reserved term?
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -----Original Message-----
: From: Ryan [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, February 11, 2003 3:26 PM
: To: CF-Talk
: Subject: Re: CFStoredProc
:
:
: Thanks, but that didn't work. We're using DB2, Solaris 8, and
: Apache 2.13.
:
:
: ----- Original Message -----
: From: "<"Everett>,Al"" <[EMAIL PROTECTED]>
: To: "CF-Talk" <[EMAIL PROTECTED]>
: Sent: Tuesday, February 11, 2003 2:17 PM
: Subject: RE: CFStoredProc
:
:
: > I've found that cfcprocresult should be last. (Oracle 8i/9i). Try that.
: >
: > > -----Original Message-----
: > > From: Nuovo [mailto:[EMAIL PROTECTED]]
: > > Sent: Tuesday, February 11, 2003 3:13 PM
: > > To: CF-Talk
: > > Subject: CFStoredProc
: > >
: > >
: > > Ok, gang,
: > >
: > > The following stored proc call works beautifully:
: > >
: > > <cfstoredproc procedure="test" datasource="#ds#">
: > > <cfprocresult name="getAdID">
: > > </cfstoredproc>
: > >
: > > It inserts a record into our test table and returns the ADID
: > > (INTEGER, autonumber) and DESC (CHAR, defaults to "TEST") fields.
: > >
: > > Then I try to pass the proc a value for DESC as follows:
: > >
: > > <cfstoredproc procedure="test" datasource="#ds#" debug="Yes">
: > > <cfprocresult name="getAdID">
: > > <cfprocparam dbvarname="DESC" value="Ryan"
: > > cfsqltype="CF_SQL_CHAR" type="In">
: > > </cfstoredproc>
: > >
: > > And I get the following error:
: > >
: > > Error Diagnostic Information
: > > DB2 Error Code = -10013
: > >
: > > [IBM][CLI Driver][DB2/SUN] SQL10013N The specified
: > > library "/export/home/testingUser/sqllib/function/test" could
: > > not be loaded.
: > >
: > >
: > >
: > > SQL = "test"
: > >
: > > Data Source = "TESTING"
: > >
: > >
: > > The error occurred while processing an element with a
: > > general identifier of (CFSTOREDPROC), occupying document
: > > position (15:1) to (15:61).
: > >
: > >
: > > Date/Time: Tue Feb 11 13:56:01 2003
: > > Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
: > > 5.0; T312461; .NET CLR 1.0.3705)
: > > Remote Address:
: > >
: > >
: > >
: > >
: > > I'm stumped, any thoughts?
: > >
: > > Thanks,
: > >
: > > Ryan
: > >
: >
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
