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