- see footer for list info -<
can you confirm that the SP actually IS returning a variable?
also - isn't the variable returned as a variable in itself? ie - just variables.schmoo? On 6/28/06, Tomo <[EMAIL PROTECTED]> wrote:
>- 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 -<
