>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?
well if it's already set to a date and when I update it I leave it blank, then it'll keep the date.
During the insert, I guess I can have a <cfif> to leave it out, but it's still a problem for the update.
Deanna, I looked up YesNoFormat, but I don't really get it as of yet.
[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
- Re: no end date daniel kessler
- Re: no end date daniel kessler