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