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.

Victoria...




"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...>
cc:
Subject:  Null dates


Hello:

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,

Jed


---
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
victoria.seltser@p...
$subst('Email.Unsub')








  Return to Index