>- 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 -<
