We have a DB2 stored proc that inserts a record and returns the recordset,
which has only two fields: adID and desc. When using the cfstoredproc tag,
I can't get the results of the insert back in my cfoutput; referencing
#adID# or #desc# throws "error resoling parameter". I did a cfdump of the
cfprocresult name and I get back "1" and the correct adID; #columnList#
yields "1". Any ideas? Code is below, but probably not helpful 'cause it's
just a test.
<cfstoredproc datasource="#ds#" procedure="test">
<cfprocresult name="insert">
</cfstoredproc>
<cfdump var="#insert#">
Ryan Farrell .:i:. Programmer
Nuovo Technologies
[EMAIL PROTECTED]
850-939-1548 x16
http://www.nuovotech.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
