Hello Jared, thanks for the tip. I was trying your example but is not working for me. Here is a my function:
<cffunction name="updatePKG" returntype="any"> <cfargument name="in_table" type="any" required="false" default=""> <cfargument name="in_column" type="any" required="false" default=""> <cfargument name="in_new_value" type="any" required="false" default=""> <cfargument name="in_where" type="any" required="false" default=""> <cfset var loc = structnew() /> <cfstoredproc procedure = "sp_test" datasource="#Application.Global.dsn#" username="#Application.Global.dsnUN#" password="#Application.Global.dsnPW#" > <cfprocresult name= "rs1"> <cfprocparam type = "IN" cfsqltype="cf_sql_varchar" value="#arguments.in_table#"> <cfprocparam type = "IN" cfsqltype="cf_sql_varchar" value="#arguments.in_column#"> <cfprocparam type = "IN" cfsqltype="cf_sql_varchar" value="#arguments.in_new_value#"> <cfprocparam type = "IN" cfsqltype="cf_sql_varchar" value="#arguments.in_where#"> <cfprocparam type = "OUT" cfsqltype="cf_sql_varchar" value="results"> </cfstoredproc> <cfreturn loc.rs1> </cffunction> I have seem many samples with the IN paremeter, but not with the out. How would you put the OUT parameter in the struct in order to return the struct and use the OUT paremeter value later? Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
