Yes, it's fine to have a null value in a datetime field, but you have to be
sure you're not passing anything other than a datetime value into it. It's
possible that you're trying to send in a blank value, which is actually a
set of spaces as opposed to nothing at all, which would be a null value.
What I do is put a CFIF around the parts of the SQL statement that involve
dates. If there's no date present, I just do nothing with that field.
---mark
=========================================
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
=========================================
-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 28, 2001 10:38 PM
To: CF-Talk
Subject: SQL Datatype Datetime
Is it possible to have a null Datetime field although I have allowed
nulls, it still complains. Or would it be better to have a very distant
past date...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
