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 I would appreciate even if you give your suggestions..
=============================================================
<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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
