How to send a null date to <cfqueryparam and avoid NullPointerException

[nikos101]

how can I avoid the error

faultCode:Server.Processing faultString:'Unable to invoke CFC - The cause of this output exception was that: java.lang.NullPointerException.' faultDetail:''

when I send a null date to

,<cfqueryparam cfsqltype="cf_sql_timestamp"   value="#ARGUMENTS.object.dateAcknowledged#" null="#isNull(ARGUMENTS.object.dateAcknowledged)#">

[Dan_Bracuk]

Try replacing this:

null="#isNull(ARGUMENTS.object.dateAcknowledged)#

with something like this

null="#not isDate(ARGUMENTS.object.dateAcknowledged)#

[nikos101]

thx, but

its not valid cfxml

The CFML compiler was processing:<ul><li>The tag attribute cf_sql_timestamp,

[Dan_Bracuk]

Back up a bit.  The objective is to come up with a function that looks at arguments.object.dateacknowledged and returns either true or false, right?  That being the case, cfdump and cfabort are your freinds.  See what isDefined, isDate, StructkeyExists, etc return when you do and don't have a value in that structure.

[nikos101]

sorry, what i meant was the parser is not accepting

,<cfqueryparam cfsqltype="cf_sql_timestamp"   value="#ARGUMENTS.object.dateAcknowledged#" null="#not isDate(ARGUMENTS.object.dateAcknowledged)#>

[nikos101]

stick the code elsewhere and works

    <cfset is_null = not isDate(ARGUMENTS.object.dateAcknowledged)>