perfect ;-)
ta
Ian W
----- Original Message -----
From: "Rich Wild" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 10:43 AM
Subject: RE: [ cf-dev ] deleting dates...
> 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]
>
--
** 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]
