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 Annsounds like you need to have 3 different [date] fields. As it is now youmay be overwriting the same field each time a new value is entered.>>>>>>>>>>><<<<<<<<<<>>>>>>>>>><<<<<<<<<<<
Associated Messages, from the most recent to the oldest:
>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 Annsounds like you need to have 3 different [date] fields. As it is now youmay be overwriting the same field each time a new value is entered.>>>>>>>>>>><<<<<<<<<<>>>>>>>>>><<<<<<<<<<<
andre@adsp.com (de Saint Phalle, Andre)
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...