Re: Appending current [date] to a database

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 14755
interpreted = N
texte = Grant Hulbert wrote:> >Question: I have a pretty simple
here that appends to a database and is > >working just fine. However, I just realized that when the data is appended, > >the date that is sent is the date the page was loaded, not the date/time the > >response is actually generated, so that is kind of screwing up my sort by > >date and time setup I have on the results page. > > I assume the symptom you're trying to avoid is when someone sits there staring at the page for hours, then clicks the submit button. The problem here is that you've stuck the date into the which is sitting on the client's browser. The solution is to use an [Append] context instead, which allows you to set all the field values at the time of submission: > > Get rid of your $Append in your current form, and then embed [Append] into *discussion.tmpl* (the page that displays after they hit submit).See, this is why those of us that use WebCat tend to be pretty fanatical about the product. Not only does Grant provide a simple solution to my problem, but he responds on a Sunday afternoon. With this kind of suppport, it seems almost a bonus that WebCat is the fastest, most flexible solution for database publishing on any platform. -- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (732) 469-2567 * * 429 St. Giles Court * FAX: (732) 469-5823 * * Somerset, NJ * e-mail: help@altimac.com * * 08873 * WWW: http://www.altimac.com * ************************************************************** Associated Messages, from the most recent to the oldest:

    
  1. Re: Appending current [date] to a database (Gil Poulsen 1997)
  2. Re: Appending current [date] to a database (Grant Hulbert 1997)
  3. Appending current [date] to a database (Gil Poulsen 1997)
Grant Hulbert wrote:> >Question: I have a pretty simple here that appends to a database and is > >working just fine. However, I just realized that when the data is appended, > >the date that is sent is the date the page was loaded, not the date/time the > >response is actually generated, so that is kind of screwing up my sort by > >date and time setup I have on the results page. > > I assume the symptom you're trying to avoid is when someone sits there staring at the page for hours, then clicks the submit button. The problem here is that you've stuck the date into the which is sitting on the client's browser. The solution is to use an [append] context instead, which allows you to set all the field values at the time of submission: > > Get rid of your $Append in your current form, and then embed [append] into *discussion.tmpl* (the page that displays after they hit submit).See, this is why those of us that use WebCat tend to be pretty fanatical about the product. Not only does Grant provide a simple solution to my problem, but he responds on a Sunday afternoon. With this kind of suppport, it seems almost a bonus that WebCat is the fastest, most flexible solution for database publishing on any platform. -- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (732) 469-2567 * * 429 St. Giles Court * FAX: (732) 469-5823 * * Somerset, NJ * e-mail: help@altimac.com * * 08873 * WWW: http://www.altimac.com * ************************************************************** Gil Poulsen

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:

[WriteFile] problems (1997) all records returned. (1997) WCS Newbie question (1997) WebCat2_Mac RETURNs in .db (1997) We have Proof (1997) Help formatting search results w/ table (1997) Determining Method (2000) WebCat2: multiple currency support (1997) WebCatalog Technical Reference (1997) Version f1 status (1997) Date search - yes or no (1997) [BoldWords] WebCat.acgib15Mac (1997) [SMSI] WebDNA is too good to go away! (2006) Directory Overload (1998) Emailer Set Up (1997) Cart sweeper (2000) SQL on OSX Client (2001) emailer truncates last letter! (1997) Confused about Grep Syntax (2004) Word wrapping (1997)