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:

    
  1. Re: Problem with date and ranges (Gary Krockover 2002)
  2. Re: Problem with date and ranges (dale's stuff 2002)
  3. Re: Problem with date and ranges (sally 2002)
  4. Re: Problem with date and ranges (Glenn Busbin 2002)
  5. Re: Problem with date and ranges (WJ Starck 2002)
  6. Problem with date and ranges (Nitai @ ComputerOil 2002)
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:

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)