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 theusers 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 thisexample the item shows.Now if I add another items that should show on the 12/15/02, also, then sofar it does not work.The db looks like this:item start_date end_date priceItem1 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 asdates.Any help very much appreciated.SincerelyNitai AventaggiatoCEO-- Tools to energize your businessContent Management & eBusiness SystemsComputerOil GmbH http://computeroil.com/Hauptstrasse 12 info@computeroil.com8252 Schlatt/SwitzerlandTel: +41 (0)52 654 15 55Fax: +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 theusers 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 thisexample the item shows.Now if I add another items that should show on the 12/15/02, also, then sofar it does not work.The db looks like this:item start_date end_date priceItem1 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 asdates.Any help very much appreciated.SincerelyNitai AventaggiatoCEO-- Tools to energize your businessContent Management & eBusiness SystemsComputerOil GmbH http://computeroil.com/Hauptstrasse 12 info@computeroil.com8252 Schlatt/SwitzerlandTel: +41 (0)52 654 15 55Fax: +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:
Search/sort in URL Was: GuestBook example (1997)
[url] link (1998)
WCS Newbie question (1997)
WebCat2 - storing unformatted date data? (1997)
same products but different (1998)
docs for WebCatalog2 (1997)
[WebDNA] Variable mystery (2009)
RE: [WebDNA] Build Name for 6.1 (2008)
Cart Number sequence (1997)
Emailer setup (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
html pages not working (2003)
Error Messages Returned to User (1997)
Practice runs ? (1997)
Download Question (1997)
[OT] Server check please (2006)
Help name our technology! I found it (1997)
Multiple fields on 1 input (1997)
autosensing lanague selection (1997)
autocommit problem (1998)