here's how ya get at a fucntion that is part of a package: <cfstoredproc procedure="schemaName.packageName.functionName" datasource="#datasource#" username="#userid#" password="#passwd#"> <cfprocparam type="In" cfsqltype="CF_SQL_BIGINT" dbvarname="varName1" value="varValue1"> <cfprocparam type="In" cfsqltype="CF_SQL_BIGINT" dbvarname="varName2" value="varValue2"> <cfprocparam type="Out" cfsqltype="CF_SQL_BIGINT" dbvarname="DBoutVarName" variable="outVarName"> </cfstoredproc>
HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238643 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54