if the field is nullable then do
SET myDate = NULL
if not, then you'll have to add a date in the past and then remember that
date as invalid in your app. The problem is that you're trying to add an
invalid date ('') to the column.
> -----Original Message-----
> From: Ian Westbrook [mailto:[EMAIL PROTECTED]
> Sent: 06 October 2003 10:34
> To: cfug dev list
> Subject: [ cf-dev ] deleting dates...
>
>
> Hi
> I've got a date in a field (ODBC date): how do I delete it?
> I've tried setting the field to '' but that throws an error...
>
> CF4.5, Access db
>
> TIA
>
> Ian W
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
