- see footer for list info -<
/me high-fives Gene
Yea.. mango-kru in da house! no worries Tom On 6/28/06, Tomo <[EMAIL PROTECTED]> wrote:
>- see footer for list info -< Rich/Gene, THanks for that.. . didn't quite expect that to happen:) Much better now:) Tom Gene Brown wrote: >> - 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 -< > ___________________________________________________________ Yahoo! Messenger - with free PC-PC calling and photo sharing. http://uk.messenger.yahoo.com _______________________________________________ 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 -<
