null="#YesNoFormat(NOT Len(myvar))#">
Maybe the cfsqltype needs another value depending on the DB
Pascal
> -----Original Message-----
> From: cf coder [mailto:[EMAIL PROTECTED]
> Sent: 24 September 2004 14:52
> To: CF-Talk
> Subject: datetime problems - 01/01/1900
>
> Hello,
>
> I'm assuming this one should be an easy one. I'm running an insert
query
> and one of the fields is date/time. When I DO NOT send a value to it,
I
> want to insert is as <NULL>, but instead, it's going in as "1/1/1900".
>
> How should I do my query where I can send a NULL Value?
>
> Thanks,
>
> cfcoder
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
