Check to see if Request.Form("txtWhatever") is a zero length string (""). If
it is, then insert a NULL into the database for that field.

Please change the subject when you start a new topic
Please *snip* all the unnecessary stuff from the bottom of your post

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "arshad siddiqui" <ash_arshad@y...>
Subject: [asp_databases] RE: Sql server database problem


: Thanks fro you help
: There is one more problem
: when I am entering date into the database through my
: ASP page.if I leave the textbox blank then it is
: inserting date as "01-01-1900".I know that it
: inserting the default date but I want to keep it empty
: because I want to dispalay the inserted things on
: another page and there it shows the date.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~