Posted by bjose21 on 10/01/45 11:38

Hello,

Thanks for your responses. I was able to get around this within the asp
code by basically stating..if there is a date in the field then write
to SQL. However if there is no date then do not write anything to SQL
for that particular field. Seems to be working great. Below is a sample
of the asp code


If IsDate(cDateClosed) Then
sql = sql & ", dateClosed='"& cDateClosed & "'"
End If

• Next in forum: Re: Seeking correct syntax to pass a NULL value for a datetime field from an asp page to SQL
• Prev in forum: Re: Audit Logon / Audit Logoff problem with SQL 2K
• Thread view: Re: Seeking correct syntax to pass a NULL value for a datetime field from an asp page to SQL

[Reply to this message]