or does it put null?
....tony
r e v o l u t i o n w e b d e s i g n
[EMAIL PROTECTED]
www.revolutionwebdesign.com
its only looks good to those who can see bad as well
-anonymous
-----Original Message-----
From: Arden Weiss [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:44 PM
To: CF-Talk
Subject: How to post a null date variable to a table
How to post a null date to SQL Server 2000 via a variable instead of
just using the word "Null" or do I have to use an embedded CASE
statement.
<CFQUERY NAME="UP2" DATASOURCE="test">
UPDATE mytable
SET
APPL_DATE = #APPL_DATE# , <-- This has a valid date and works fine
APRV_DATE = Null <-- This posts a Null Date to "mytable"
WHERE L_NUMBER = '#mFINDIT#'
</CFQUERY>
Hope the question is clear...
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
