A classic issue yesterday related to isDefined():
This worked perfectly:
<cfscript>
//pass boolean to determine if the given field is null in the
stored proc (1=submitted, 2=finalized)
if(arguments.status eq 1){
submitted = false;
finalized = true;
}
else if(arguments.status eq 2){
finalized = false;
submitted = true;
}
</cfscript>
<cfstoredproc datasource="#this.datasource#"
procedure="prc_updateReportStatus">
<cfprocparam cfsqltype="CF_SQL_INTEGER" value="#this.reportid#">
<cfprocparam cfsqltype="CF_SQL_INTEGER" value="#this.userid#"
null="#submitted#">
<cfprocparam cfsqltype="CF_SQL_INTEGER" value="#this.userid#"
null="#finalized#">
<cfprocresult name="qry">
</cfstoredproc>
This did not:
<cfscript>
//pass boolean to determine if the given field is null in the
stored proc (1=submitted, 2=finalized)
if(arguments.status eq 1){
submitted = true;
}
else if(arguments.status eq 2){
finalized = true;
}
</cfscript>
<cfstoredproc datasource="#this.datasource#"
procedure="prc_updateReportStatus">
<cfprocparam cfsqltype="CF_SQL_INTEGER" value="#this.reportid#">
<cfprocparam cfsqltype="CF_SQL_INTEGER" value="#this.userid#"
null="#isDefined('submitted')#">
<cfprocparam cfsqltype="CF_SQL_INTEGER" value="#this.userid#"
null="#isDefined('finalized')#">
<cfprocresult name="qry">
</cfstoredproc>
I ran a DB trace and both values were coming out as defined in the second
code.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336747
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
