This doesn't work with IN/OUTs:
<cfquery name="test" datasource="ork">
{ CALL ASTDTCCK.TESTPRC14('12345678', '#Variables.Price#') }
</cfquery>
But I guess you knew that. ;-|
-----Original Message-----
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 7:30 AM
To: CF-Talk
Subject: RE: AS400 Stored Procedure without using CFSTOREDPROC? -
Anyone?
Can you not do it any other way?
-----Original Message-----
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 7:59 AM
To: CF-Talk
Subject: AS400 Stored Procedure without using CFSTOREDPROC?
<CFSTOREDPROC PROCEDURE="ASTDTCCK.TESTPRC14" DATASOURCE="ork" DEBUG="Yes">
<CFPROCPARAM TYPE="IN" cfsqltype="CF_SQL_CHAR" VALUE="12345678"
variable="dealer_number">
<CFPROCPARAM TYPE="INOUT" cfsqltype="CF_SQL_CHAR" VALUE="ABCDEFG"
variable="price">
</CFSTOREDPROC>
The above stored proc works against the AS400. How can I do the same thing
but without using the cfstoredproc tag?
<cfquery name="test" datasource="ork">
What would I put here?
</cfquery>
Thanks,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
