p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

proasp_howto thread: Null dates

Message #1 by "Jed W. Petrovich" <jwpetrov@q...> on Tue, 20 Mar 2001 11:21:59 -0700
Create default constraint of NULL for the date column in the database, then
if you don't provide the value it will insert NULL.


"Jed W. Petrovich" <jwpetrov@q...> on 03/20/2001 01:21:59 PM

Please respond to "How To" <proasp_howto@p...>

To:   "How To" <proasp_howto@p...>
Subject:  Null dates


I'm trying to create an Insert statement that will handle null date values.
If I pass a date, my statement works fine. However, if there is no date
entered into the form, the value "1/1/1900" is displayed when the record is
viewed. I can't seem to figure out how to stop the "1/1/1900" from showing
up in the record. FYI, I have three date values in this table that I have
to deal with in the same manner.

Thanks much,


SoftArtisans helps developers build robust, scalable Web applications!
Excel Web reports, charts: http://www.softartisans.com/excelwriter.html
File uploads: http://www.softartisans.com/saf.html
Transactional file management: http://www.softartisans.com/saf1.html
Scalability: http://www.softartisans.com/saxsession.html
ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html

  Return to Index