Calling a DB2 stored procedure such as:
<cfquery name="StoredProc"
datasource=#attributes.db2source#
username=#attributes.db2account#
password=#attributes.db2pass#>
{CALL TSIS.STORPRS6('R','123456789',NULL,NULL)}
</cfquery>
<cfoutput query="storedproc">
#storedproc.columnlist#
</cfoutput>
Produces:
1,2,3,4,5,6,7,8
I can't get to the data as variable references like #storedproc.1# produce a
CF error. It seems like there must be a way to name the columns on a stored
procedure.
Which direction direction should this be tackled from? Is this a DB2 stored
procedure error or is there some CF trick I've missed?
Thanks!
Brian
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
