To update a field to NULL, use CFQUERYPARAM with NULL="yes"
-----Original Message-----
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Monday, 4 October 2004 10:29
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?
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]
