the case, not sending it a value will make the DB insert the value that
you're seeing. You need to redefine that field so that it accepts NULL
values.
________________________________
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: Friday, September 24, 2004 8:52 AM
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]