Re: auto enter dates

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18759
interpreted = N
texte = >I have a Form where someone adds a record to a database. This record has >3 dates attached to it - DateToExpire, DateEntered, DateModified. > >The database administrator will always be able to change the DateToExpire >field. >When the record is first entered, I want the DateEntered and DateModified >fields to automatically be today's date (assuming it's entered today). >I've gotten this to show up on the Form itself, but it isn't getting into >my database. > >Also, when the record is edited, I want the DateModified field to update >to today's date. And keep the DateEntered field the same. > > >So far, I've gotten the Date Entered field to show up in the Add.tpl, I'm >using this to >hide my DateModified field. BUT, neither field is getting into my >database. Out of the 3 dates, only the one that the user manually types >in shows up. The DateEntered and DateModified fields don't. > >How do I transfer this value to my database? > >Sue Ann sounds like you need to have 3 different [date] fields. As it is now you may be overwriting the same field each time a new value is entered.>>>>>>>>>>><<<<<<<<<<>>>>>>>>>><<<<<<<<<<< Associated Messages, from the most recent to the oldest:

    
  1. Re: auto enter dates (Sue Ann Sanders 1998)
  2. Re: auto enter dates (Sue Ann Sanders 1998)
  3. Re: auto enter dates (Paul Willis 1998)
  4. Re: auto enter dates (Sue Ann Sanders 1998)
  5. Re: auto enter dates (andre@adsp.com (de Saint Phalle, Andre) 1998)
  6. auto enter dates (Sue Ann Sanders 1998)
>I have a Form where someone adds a record to a database. This record has >3 dates attached to it - DateToExpire, DateEntered, DateModified. > >The database administrator will always be able to change the DateToExpire >field. >When the record is first entered, I want the DateEntered and DateModified >fields to automatically be today's date (assuming it's entered today). >I've gotten this to show up on the Form itself, but it isn't getting into >my database. > >Also, when the record is edited, I want the DateModified field to update >to today's date. And keep the DateEntered field the same. > > >So far, I've gotten the Date Entered field to show up in the Add.tpl, I'm >using this [date]> to >hide my DateModified field. BUT, neither field is getting into my >database. Out of the 3 dates, only the one that the user manually types >in shows up. The DateEntered and DateModified fields don't. > >How do I transfer this value to my database? > >Sue Ann sounds like you need to have 3 different [date] fields. As it is now you may be overwriting the same field each time a new value is entered.>>>>>>>>>>><<<<<<<<<<>>>>>>>>>><<<<<<<<<<< andre@adsp.com (de Saint Phalle, Andre)

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

multi-paragraph fields (1997) Interfacing WebMerchant to www.fedex.com (1997) case number with spaces. (2000) Sorting problem (2002) Stumped on ShipCosts.db Problem (2000) Major problem (1999) international time (1997) Secure server question (1997) Help formatting search results w/ table (1997) WebCatalog can't find database (1997) WebCat b13 CGI -shownext- (1997) can webcat create directories on NT? (1997) Add to Cart & List of Products (1997) CC Processors question (2002) WebCatalog for guestbook ? (1997) form data submission gets truncated (1997) Help name our technology! I found it (1997) access denied problem (1997) RE: [WebDNA] HTTP Streaming - POSSIBLE! (2010) Multiple prices (1997)