use NULL. Best bet would be to set the end data in the DB as defaulting to
NULL and that way you can pass an end date or not.
_____
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: 04 October 2004 15:01
To: CF-Talk
Subject: RE: no end date
There is no NULL in CF so that won't work. The idea is to set it NULL in the
DB, which will return an empty (blank) value in the query in CF.
Why is the blank a problem?
-----Original Message-----
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Monday, 4 October 2004 9:55
To: CF-Talk
Subject: Re: no end date
>Set it to NULL.
I tried this, but it said, "null is not defined":
<cfset the_end_date = NULL>
Leaving it blank is not an option because I may have to change a date into
"no date". So, I hate to sound daft, but how do I set it to null?
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
