Re: Problem with summary on date / inconsequent webcat behaviour

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19126
interpreted = N
texte = Thank you very much, Ken. This might be just what I need. And since the administration pages for my db solution are well structured, I might get the time to modify the whole thing before hitting the deadline! THANKS!I hope PCS correct these problems in the 3.0 version.>>>I had all kinds of problems with WebSTAR crashes when working >>>with dates. I followed Ken's advice and stored dates as numbers in my >>>databases. Now searches are much faster and no crashes. > >>What do you mean by 'numbers'? Do date fields in your database contain '/' >>to seperate dd/mm/yyyy or is it all a string of digits? > >He means storing dates as the number of days since 00/00/0000. > >>>I don't recall the URL of the info from Ken, but he had posted >>>guidelines for using this format for dates on his site. > >It's here: http://webdna.net/dates.html > >Sincerely, >Ken Grome >808-737-6499 >WebDNA Solutions >mailto:ken@webdna.net >http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: Problem with summary on date / inconsequent webcat behaviour (Per Christian Lied 1998)
  2. Re: Problem with summary on date / inconsequent webcat behaviour (Kenneth Grome 1998)
  3. Problem with summary on date / inconsequent webcat behaviour (Per Christian Lied 1998)
  4. Re: Problem with summary on date / inconsequent webcat behaviour (Gil Poulsen 1998)
Thank you very much, Ken. This might be just what I need. And since the administration pages for my db solution are well structured, I might get the time to modify the whole thing before hitting the deadline! THANKS!I hope PCS correct these problems in the 3.0 version.>>>I had all kinds of problems with WebSTAR crashes when working >>>with dates. I followed Ken's advice and stored dates as numbers in my >>>databases. Now searches are much faster and no crashes. > >>What do you mean by 'numbers'? Do date fields in your database contain '/' >>to seperate dd/mm/yyyy or is it all a string of digits? > >He means storing dates as the number of days since 00/00/0000. > >>>I don't recall the URL of the info from Ken, but he had posted >>>guidelines for using this format for dates on his site. > >It's here: http://webdna.net/dates.html > >Sincerely, >Ken Grome >808-737-6499 >WebDNA Solutions >mailto:ken@webdna.net >http://www.webdna.net Per Christian Lied

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:

emailer settings and control questions (1997) RE: Purchased cart being overwritten - still !?? (1997) Doesn't change (WebCat 4.0) (2000) Add a field to the error log? (1997) Protect (1997) I'm tired of all this! (2000) [WebDNA] remove html comments (2009) WebCat B13 Mac CGI -- Frames question (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) search between two dates (2003) bcc and sendmail (2001) Re2: frames & carts (1997) Summary search -- speed (1997) Size of a folder? (2003) RE: IIS4b2 and WebCatalog b19 (1997) automating txt downloads for conversion to webcat db (2006) [format 40s]text[/format] doesn't work (1997) WCS Newbie question (1997) Million product store (2003) carriage returns in data (1997)