[thelist] 1/1/1900 SQL Server/ASP Question
josh
evolt at efeingold.com
Wed Jan 16 13:46:15 CST 2002
I am updating a database field via a web form. When a date is placed in the
field the database updates correctly. When the form is left blank, the
database assumes the value 1/1/1900.
Here is the database update call:
<code snippet>
rs.Open "UPDATE t_table SET t_cr_ccss_review_date = '" &
request.form("the_date") & "' WHERE id=" & request.form("id")
</code snippet>
Does anyone know what I have done wrong?
Thanks,
Josh
More information about the thelist
mailing list