-----Original Message-----
From: Arden Weiss [mailto:[EMAIL PROTECTED]
Sent: Tue 4/6/2004 9:44 PM
To: CF-Talk
Cc:
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]
