>- see footer for list info -< Tom, If you are returning an SQL variable from the SP then you reference the output variable and don't need the cfprocresult tag.
This is assuming your variable is configured as an output variable in the SP itself. Cheers Gene -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tomo Sent: Wednesday, June 28, 2006 1:08 PM To: Coldfusion Development Subject: Re: [CF-Dev] weird stored proc woes >- see footer for list info -< Gene, Thanks ;) Didn't work though - you'll notice I have an "inout", which is what I am trying to return... Any ideas still fully appreciated. Thanks, Tom Gene Brown wrote: >> - see footer for list info -< > > Tomo, > > You mention you are returning a variable from the SP, you just need to > handle #bob# as an output variable. > > <cfprocparam type="out" cfsqltype="cf_sql_integer" variable="bob"> > > You will need to use the correct cfsqltype. > > > Cheers > Gene > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tomo > Sent: Wednesday, June 28, 2006 12:56 PM > To: Coldfusion Development > Subject: [CF-Dev] weird stored proc woes > >> - see footer for list info -< > Hey All, > > I'm having a brain fart.... any help would be appreciated... > > I've got a stored proc which does an insert, and then returns a variable > > based on the id created... for the life of me, I can't seem to return > this var - it must me something I am missing... I should point out I > have no control over the stored proc right now as it's not on one of my > systems. > > The code I am running is: > > <cfstoredproc datasource="****" procedure="usp_create_msg_header" > debug="true" > > > <cfprocparam type="inout" variable="schmoo" null="true" > cfsqltype="CF_SQL_INTEGER"> <!--- header id ---> > > <cfprocparam type="in" value="this is a test" > cfsqltype="CF_SQL_VARCHAR" maxlength="20"> <!--- name ---> > > <cfprocparam type="in" value="#createUUID()#" > cfsqltype="CF_SQL_VARCHAR" maxlength="50"> <!--- transactionNo ---> > > <cfprocparam type="in" value="0" cfsqltype="CF_SQL_INTEGER"> > <!--- > status ---> > > <cfprocparam type="in" value="pipe" cfsqltype="CF_SQL_VARCHAR" > maxlength="50"> <!--- web no ---> > > <cfprocparam type="in" value="" cfsqltype="CF_SQL_VARCHAR" > maxlength="50"> <!--- loginno ---> > > <cfprocresult name="bob"> > > </cfstoredproc> > > When I try to dump #bob# it blows up in my face "bob is undefined". > When I have full sql debugging on, it shows me the result set us > there... very very odd - I'm hoping this really is just a brain fart. I > > believe it will be!!! > > Thanks, > > Tom > > > ___________________________________________________________ > Now you can scan emails quickly with a reading pane. Get the new Yahoo! > Mail. http://uk.docs.yahoo.com/nowyoucan.html > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- >> - Hosting provided by www.cfmxhosting.co.uk -< >> - Forum provided by www.fusetalk.com -< >> - DHTML Menus provided by www.APYCOM.com -< >> - Lists hosted by www.Gradwell.com -< >> - CFdeveloper is run by Russ Michaels, feel free to volunteer your help > -< > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- >> - Hosting provided by www.cfmxhosting.co.uk -< >> - Forum provided by www.fusetalk.com -< >> - DHTML Menus provided by www.APYCOM.com -< >> - Lists hosted by www.Gradwell.com -< >> - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > ___________________________________________________________ Now you can scan emails quickly with a reading pane. Get the new Yahoo! Mail. http://uk.docs.yahoo.com/nowyoucan.html _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
