That example was good. It helped part of my situation, but remember that my
<cfstoredproc> is inside a <cffunction>. I would like to know how to do that.
I spent a few more minutes trying something, and it's working the way I want it.
This is my final solution:
The 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 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" variable="results">
</cfstoredproc>
<cfset loc = {
r1 = rs1,
r2 = "#results#"
} />
<cfreturn loc>
</cffunction
I need to do something like this because I wanted to used the output variable
from my calling javascript function. Now I can use it.
Thanks to you all guys,
You are the best!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:322293
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
