Question
cfif database issue
Any idea why my code is excuting even though my database
column lunch_out_time is blank/null?
<cfif getpeople.lunch_out_time NEQ "">
<cfset time2 = TimeFormat(getpeople.lunch_out_time, "hh:mm")>
<cfset time3 = DateAdd("h", 1, time2)>
<cfset time4 = DateAdd("n", 15, time3)>
<cfset time5 = Timeformat(time4, "hh:mm")>
<cfset time55 = Now()>
<cfset time555 = DateAdd("h", 1, time55)>
<cfset time6 = Timeformat(time555, "hh:mm")>
<cfif time5 LTE time6 AND getpeople.emailed EQ 2>
<cfif getpeople.lunch_out_time NEQ "">
<cfset time2 = TimeFormat(getpeople.lunch_out_time, "hh:mm")>
<cfset time3 = DateAdd("h", 1, time2)>
<cfset time4 = DateAdd("n", 15, time3)>
<cfset time5 = Timeformat(time4, "hh:mm")>
<cfset time55 = Now()>
<cfset time555 = DateAdd("h", 1, time55)>
<cfset time6 = Timeformat(time555, "hh:mm")>
<cfif time5 LTE time6 AND getpeople.emailed EQ 2>
