It's possible, Ben, but we've tried this with a non-testing table that doesn't have any reserved words as field names and we get the same error. Good eye, though, good eye, mmhmmm.
Ryan ----- Original Message ----- From: "Ben Doom" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 2:47 PM Subject: RE: CFStoredProc > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
