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