Thanks the Null entry appears to work.

Dwayne Cole, MS in MIS, MBA
Certified Advanced ColdFusion Developer
850-591-0212

---------- Original Message ----------------------------------
From: "Barney Boisvert" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Thu, 18 Dec 2003 14:00:09 -0800

>Make sure it's set to allow NULL values in the design screen for the table,
>and they just insert a NULL in your query:
>
>Insert into myTblae
> (myDateField)
>Values
> (NULL)
>
>
>> -----Original Message-----
>> From: Dwayne Cole [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, December 18, 2003 1:49 PM
>> To: CF-Talk
>> Subject: empty date field
>>
>> How do you enter an "empty" variable into and access
>> database.  The date field in my form is not required.  In
>> fact if no date has been set then I want to enter an empty value.  
>>
>> Dwayne Cole, MS in MIS, MBA
>> Certified Advanced ColdFusion Developer
>> 850-591-0212
>>  
>>
>>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to