even sql does not like a '' value for a dte/time field. You need to insert "NULL" if the field is ""
"Success is a journey, not a destination!!" Doug Brown ----- Original Message ----- From: "sebastian palmigiani" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 28, 2002 2:05 PM Subject: time field in access > I have an Access db with a date/time value with a medium time format (0:00 > am). The field is set as not required. > > When the form is left blank for the time value and the query insert is > attempted you get > > StartTime > '' > > But then you get the error message: > > data type mismatch in criteria expression > > How do I insert an empty value or a null value into that date/time field? > > > Sebastian > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists