Hi,
Here I am giving the testcode which I executed in cfmx version and CF4.5.1
version.
But I am expecting value '4' from following code. I will be getting that
value in only CF4.5.1 but not in CFMX.
Is it unknown cfmx bug or do we need to change any attributes kind of
things when we use cfstoreproc in cfmx.
Really appreciated for your suggestions also..
=============================================================
<cfstoredproc procedure="pkg_security.sp_check_security"
datasource="#defaults.dsn#"
username="#client.user_name#"
password="#client.password#">
<!--- TRACK #160 - Security Update --->
<cfprocparam type="In"
cfsqltype="CF_SQL_INTEGER"
dbvarname="user_id_in"
value="100023">
<!--- TRACK #160 - Security Update --->
<cfprocparam type="In"
cfsqltype="CF_SQL_INTEGER"
dbvarname="object_id_in"
value="1" null="yes">
<!--- TRACK #160 - Security Update --->
<cfprocparam type="In"
cfsqltype="CF_SQL_VARCHAR"
dbvarname="function_name_in"
value="patient">
<!--- Replaced the deprecated attribute 'cfvarname' by 'variable' attribute
--->
<cfprocparam type="Out"
cfsqltype="CF_SQL_INTEGER"
variable ="access_key_out"
dbvarname="access_key_out">
</cfstoredproc>
<cfset test = #access_key_out#>
<cfoutput>#test#</cfoutput>
test value is 4 in cf4.5.1
and test value is 0 in cfmx .. why it is so like that.. ?
Thanks in advance..
Best regards
Sachin.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
