You can have null in the enddate column. If you're using queryparams, it'd
be something like this:
<cfquery...>
Insert into mytable (datecolumn)
values (<cfqueryparam cfsqltype="cf_sql_date" value="mydate"
null="#yesNoFormat(NOT Len(trim(mydate)))#")
I wouldn't use a fake end date - that'll come back to bite you later.
----- Original Message -----
From: "Daniel Kessler" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 04, 2004 8:24 AM
Subject: no end date
>I have a calendar of events. All events have a start date/time, but
> many of them don't have an end date/time. I can work around this by
> setting an obviously incorrect end date and checking for it (i.e.
> 12.17.66, my wife's birthday). However, I'd prefer to not set a date
> if there isn't one and check for that instead.
>
> So, what's the proper way of having no end date in the database?
> Also since this is editable information, I may have an entry with a
> date and need to set it to null or "no end date" so any suggestion
> should take this into account.
>
> I'm using the latest, greatest Oracle.
>
> good morning, and thanks.
>
> --
> Daniel Kessler
>
> Department of Public and Community Health
> University of Maryland
> Suite 2387 Valley Drive
> College Park, MD 20742-2611
> 301-405-2545 Phone
> www.phi.umd.edu
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- no end date Daniel Kessler
- Re: no end date Deanna Schneider
- Re: no end date Stephen Moretti (cfmaster)
- Re: no end date daniel kessler
- RE: no end date Robertson-Ravo, Neil (RX)
- Re: no end date daniel kessler
- RE: no end date Robertson-Ravo, Neil (RX)
- RE: no end date James Holmes
- Re: no end date daniel kessler
- Re: no end date Deanna Schneider
- RE: no end date Robertson-Ravo, Neil (RX)
- RE: no end date James Holmes