I have used the following to try and experiment with null values, but neither seemed to work
<cfquery name="foo" datasource="#application.datasource#"> <!--- sql server 2005 ---> select null as bar </cfquery> <cfdump var="#foo.bar#"> <cffunction name="GetNull" returntype="any"> <cfreturn /> </cffunction> <cfset foo = getNull()> <cfdump var="#isdefined('foo')#">
the first of course, throws on the date check in cfExchangeTask and the second causes nothing to get changed on the updated task as the value is undefined
same result as null values from java
<cfset foo = CreateObject("java", "java.util.Vector")> <cfset foo.setSize(1)> <cfset bar = foo.get(0)> <!--- returns null ---> <cfdump var="#isdefined('bar')#" />
1 person found this helpful
You might submit a comment on the livedocs page. Obviously it is not the place for coding help ;-) But, I think it would be appropriate to ask if null dates are supported. Since it does not seem to be mentioned in the documentation - one way or the other.
good idea! thanks.
I've submitted a comment.
in the meantime, does anybody happen to have any in depth knowledge about how getDate() works, perhaps that could evidence some possiblities.