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:
two questions (1997)
Cancel Subscription (1996)
Search (1997)
[OT] DOD again (2003)
sendmail spaces (1997)
showif and cart (1998)
WebStar5 and realm authentication (2003)
greater than or equal to (1997)
problems with 2 tags shakur (1997)
Performance Issue (2000)
attn: smitmicro - cart limitation (2002)
RE: Explorer oddities (1997)
Protect vs Authenicate (1997)
Variables for chat (1997)
How is it done? (1998)
RE: Still Learning (1997)
[/application] error? (1997)
WebCatalog vs. Cold Fusion (1998)
[random] only for 1-100??? (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)