Problem with date and ranges
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45809
interpreted = N
texte = Hi allGot a little problem which I need help with.On a site a user can select a start and a end date. My task is to show the users different options according to the start and end date.Example: A user enters 12/10/02 and 12/15/02.In a db I got items that should only show on the 12/13/02. So with this example the item shows.Now if I add another items that should show on the 12/15/02, also, then so far it does not work.The db looks like this:item start_date end_date price Item1 12/10/02 12/15/02 100$ item2 12/10/02 12/20/02 50$My search is like this:[search db=some.db&lestart_datedatarq=[startdate]&geend_datedatarq=[enddate]All dates are stored as numbers and are shown here for easier reading as dates.Any help very much appreciated.Sincerely Nitai Aventaggiato CEO-- Tools to energize your business Content Management & eBusiness SystemsComputerOil GmbH http://computeroil.com/ Hauptstrasse 12 info@computeroil.com 8252 Schlatt/Switzerland Tel: +41 (0)52 654 15 55 Fax: +41 (0)52 654 15 59 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi allGot a little problem which I need help with.On a site a user can select a start and a end date. My task is to show the users different options according to the start and end date.Example: A user enters 12/10/02 and 12/15/02.In a db I got items that should only show on the 12/13/02. So with this example the item shows.Now if I add another items that should show on the 12/15/02, also, then so far it does not work.The db looks like this:item start_date end_date price Item1 12/10/02 12/15/02 100$ item2 12/10/02 12/20/02 50$My search is like this:[search db=some.db&lestart_datedatarq=[startdate]&geend_datedatarq=[enddate]All dates are stored as numbers and are shown here for easier reading as dates.Any help very much appreciated.Sincerely Nitai Aventaggiato CEO-- Tools to energize your business Content Management & eBusiness SystemsComputerOil GmbH http://computeroil.com/ Hauptstrasse 12 info@computeroil.com 8252 Schlatt/Switzerland Tel: +41 (0)52 654 15 55 Fax: +41 (0)52 654 15 59 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Nitai @ ComputerOil
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:
user/password validation (1998)
Date Range search (1997)
WebCat vs MS SiteServer? (1999)
Something Simple (1998)
Variable prices and Formulas.db (1997)
Who is doing sign-ups-got it (1998)
Search design (1997)
How do you hide [math]stuff[/math] (1997)
case sensitivity in lookups (1997)
interesting (2003)
Ruby on Rails (was Looping Search) (2006)
RE: Formulas.db + Users.db (1997)
Lookup Notfound (1998)
WC 2.0 frames feature (1997)
Looking up two prices in Formulas.db (1997)
BUG in WebCatalog 4.0.1 on Mac OSX (2000)
[FoundItems] solved - thanks (1997)
Unexpected error (1997)
The beginning (1997)
Updating fields from different platforms (1998)