[thelist] Setting Default Date Values in SQL Server through A SP

Rob Smith rob.smith at thermon.com
Thu Apr 25 17:03:02 CDT 2002


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]

What else could I try?

Here's what I have:

response.write("1 " & nav.fields.item("CMSNewsID").value & "<br>")
response.write("2 " & nav.fields.item("CMSNPublishDate").value & "<br>")
nav.fields.item("CMSNPublishDate").value = NULL
response.write("3 " & nav.fields.item("CMSNPublishDate").value)

results in:

1 5
2 1/1/1900
3

which is great! but the record still indicates the default date value of:
1/1/1900
BTW, I reloaded this page hoping to get

1 5
2
3

but still received:

1 5
2 1/1/1900
3



More information about the thelist mailing list