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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists