Just a small tip. When doing a datediff in CF, make sure both values are
actually dates. I just ran a datediff where the second value (the first
date) came from a DB. The value was actually a blank and CFMX threw a
variable does not exist null error. This was not expected as the variables
all existed and the only difference was that the date value was not a date.
<CFIF datediff('d', qLastOrdered.lastdate, now()) LT 180>
I solved this by adding a simple test to make sure that the value was a
date:
<CFIF Not IsDate(qLastOrdered.lastdate) OR datediff('d',
qLastOrdered.lastdate, now()) LT 180>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192804
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
