Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ASP & smalldatetime

Author  Topic 

Scott
Posting Yak Master

145 Posts

Posted - 2000-11-19 : 14:16:31
When parsing(insert into) a zero length string from an asp form, ie: an empty field, SQL Server automatically inserts the default date of 01/01/1900.

I want to be able to submit a whole bunch of dates, some valid others blank, and then be able to update the blank ones later but all the empty fields default to 01/01/1900, I want them to default to null.

Anyone with any ideas?


   

- Advertisement -