numero = 18760
interpreted = N
texte = I do have 3 different date fields in my database. DATETOEXPIRE DATEENTERED DATEMODIFIED >>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. > >>>>><<<<<<<<<<< > >ADSP Communications >Andre de Saint Phalle >PO Box 3476 >Stowe, VT 05672 >adsp.com > >>>>><<<<<<<<<<< > > >---------------------------------------------------------------- Sue Ann Sanders Mgr of Internet Development/WebMaster sanders@sells.com Sells Printing Company 414-784-9500 16000 W. Rogers Dr. fax 414-784-8551 New Berlin, WI 53151 ----------------------------------------------------------------
Associated Messages, from the most recent to the oldest:
I do have 3 different date fields in my database. DATETOEXPIRE DATEENTERED DATEMODIFIED >>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. > >>>>><<<<<<<<<<< > >ADSP Communications >Andre de Saint Phalle >PO Box 3476 >Stowe, VT 05672 >adsp.com > >>>>><<<<<<<<<<< > > >---------------------------------------------------------------- Sue Ann Sanders Mgr of Internet Development/WebMaster sanders@sells.com Sells Printing Company 414-784-9500 16000 W. Rogers Dr. fax 414-784-8551 New Berlin, WI 53151 ----------------------------------------------------------------
Sue Ann Sanders
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...