null (null=yes means the value attribute is ignore). You need something like
the following:
<cfset mydate = "5/05/05">
<cfscript>
function reverseboolean(num) {
var newbool = '';
if (num) newbool = '0';
else newbool = '1';
return newbool;
}
</cfscript>
<cfoutput>
null="#yesnoformat(reverseboolean(isdate(mydate)))#"
</cfoutput>
----- Original Message -----
From: "Ian Skinner" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 28, 2004 12:29 PM
Subject: Strange error with NULLS
> Anybody have experience with something like this throwing an error.
>
> <cfqueryparam value="#createODBCDate(arguments.KCC_OCCUR_DTE)#" null="yes"
cfsqltype="cf_sql_date">
>
> Creates the following error:
> java.lang.NullPointerException at
coldfusion.runtime.OleDateTime.<init>(OleDateTime.java:23) at
coldfusion.runtime.OleDate.<init>(OleDate.java:14) at
coldfusion.runtime.CFPage.CreateODBCDate(CFPage.java:783) at
cfComplaint2ecfc464783162$funcADDCOMPLAINT.runFunction(C:\WebSites\Developme
nt\CPS\CFC\Complaint.cfc:137) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:286) at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:
250) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1582) at
coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTa!
> g.java:331) at
cfComplaintAction2ecfc748526927$funcPROCESSCOMPLAINT.runFunction(C:\WebSites
\Development\CPS\CFC\ComplaintAction.cfc:24) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:286) at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:
250) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139) at
coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:102) at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at
cold!
> fusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at
coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence
Filter.java:28) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at
coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:62) at
coldfusion.xml.rpc.CFCServlet.doPost(CFCServlet.java:138) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at
org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:
339) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at
jrun.servlet.jrpp.J!
> RunProxyService.invokeRunnable(JRunProxyService.java:192) at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348) at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
) at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
>
> Configuration:
> CFMX 6.1 Standard
> Windows 2000 Server
> Oracle 8i with the Oracle JDBC Thin Clint for the DSN connection
>
> Any insights would be great.
>
> --------------
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
> Confidentiality Notice: This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
