auto enter dates

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18758
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 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 Sue Ann Sanders

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:

Setting up shop (1997) [ShowNext] feature in 2.0 (1997) Is this possible in simple search? question? (1998) [Listfiles] vs Netfinder (1997) Uploading very large image files (2003) NetSplat and WebCat2 (1997) How nuch ram??? (1997) CGI Request Time Out (1997) Tuition - UK (2000) Online reference (1997) NT Manual (1997) pull downs (1997) Question about replacing words (1998) $Replace with [founditems] (1997) Closing Databases (1998) WebCatalog featured at Internet World LA... (2000) wrong authentication (1998) Database (2002) WebCommerce: Folder organization ? (1997) WebCat 4.5 Email Problems? (2003)