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

Forum|Forum|14 years ago
November 19, 2011
1 reply
2111 views

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)#">

This topic has been closed for replies.

D

Dan_Bracuk

Inspiring

Try replacing this:

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

with something like this

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

nikos101Author

Inspiring

thx, but

its not valid cfxml

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

D

Dan_Bracuk

Inspiring

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded