A workaround for handling date range search in yyyy/mm/dd form
This WebDNA talk-list message is from
1997
It keeps the original formatting.
numero = 13050
interpreted = N
texte = Many thanks to the help from the fellow webcat'ers for answers to my other questions! I thought I share a workaround I found for handling range search on dates in the old yyyy/mm/dd format. This works as a string compare, but it is handled properly because of the format.Basically you perform your search using the search action from one end of the range ala something like:In your starting tmpl you have (where your field is labelled gendata, endgendate is just a variable passed on to the following tmpl):Starting from date of but ending before Then on your resultant tmpl you have something like:[founditems][showif [Gendate]<[EndGenDate]]....[/showif][/founditems]This works great!Any hope for the new webcat version supporting <= (¾) and >= („) compares?Curt----------------------------------------------------------------------| William Curt Eggemeyer Curt@mail.bzzzzzz.com || BeeHive Technologies, Inc. || http://www.bzzzzzz.com with a WebCam in Pasadena, California |----------------------------------------------------------------------
Associated Messages, from the most recent to the oldest:
A workaround for handling date range search in yyyy/mm/dd form (w curt eggemeyer 1997)
Many thanks to the help from the fellow webcat'ers for answers to my other questions! I thought I share a workaround I found for handling range search on dates in the old yyyy/mm/dd format. This works as a string compare, but it is handled properly because of the format.Basically you perform your search using the search action from one end of the range ala something like:In your starting tmpl you have (where your field is labelled gendata, endgendate is just a variable passed on to the following tmpl):Starting from date of but ending before Then on your resultant tmpl you have something like:[founditems][showif [Gendate]<[EndGenDate]]....[/showif][/founditems]This works great!Any hope for the new webcat version supporting <= (¾) and >= („) compares?Curt----------------------------------------------------------------------| William Curt Eggemeyer Curt@mail.bzzzzzz.com || BeeHive Technologies, Inc. || http://www.bzzzzzz.com with a WebCam in Pasadena, California |----------------------------------------------------------------------
w curt eggemeyer
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...