Hi,

If I have a date value in a db record and I want to remove that date value whilst leaving the rest of the record alone how do I do it? Is it just a case of setFinishDate() or do I need to do setFinishDate(null) or setFinishDate('null')?

When I try the first option above I get the following error back:

'' is an invalid date or time string

The second option returns:

Variable NULL is undefined.

The third option returns:

The cause of this output exception was that: coldfusion.runtime.locale.CFLocaleBase$InvalidDateTimeException

: null is an invalid date or time string..

Any ideas how to clear a datetime field with reactor?

Cheers,

Dave
_______________________________________________________________________
David Phipps
Director, Chapel Studios

T +44 (0)20 7100 6980   F +44 (0)20 7100 6981   M +44 (0)7765 240899
New Broad Street House, 35 New Broad Street, London, EC2M 1NH, UK

http://www.chapel-studios.co.uk
_______________________________________________________________________

The Chapel Studios group of companies are registered in England. 'Chapel Studios' and the Chapel Studios logo are registered trademarks of Chapel Studios. The information in this email is confidential, intended solely for the addressee, and may be legally privileged. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based upon this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e- mail.



-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Reply via email to