Re: Problem with date and ranges

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45811
interpreted = N
texte = Nitai-Here's what I use to find date ranges:[search db=orders.db&neordernumdata=[blank]&group1field=orderdate&group2field=or derdate&gegroup1datarq=[startdate]&legroup2datarq=[enddate]]Where [startdate] and [enddate] are entered via a form.HTH,-Will On Friday, November 29, 2002, at 11:09 AM, Nitai @ ComputerOil wrote:> Hi all > > Got 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 Systems > > ComputerOil™ 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/ > ------------------------------------------------------------- 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)
Nitai-Here's what I use to find date ranges:[search db=orders.db&neordernumdata=[blank]&group1field=orderdate&group2field=or derdate&gegroup1datarq=[startdate]&legroup2datarq=[enddate]]Where [startdate] and [enddate] are entered via a form.HTH,-Will On Friday, November 29, 2002, at 11:09 AM, Nitai @ ComputerOil wrote:> Hi all > > Got 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 Systems > > ComputerOil™ 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/ > ------------------------------------------------------------- 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/ WJ Starck

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:

emailer (1997) More DateMath problems (1997) Nesting format tags (1997) Problem (1997) Reminder for beta testers (2000) Showif probably dumb question (1997) OT: Let's see your workspace... (2005) OFF-TOPIC: For Gary Krockover ... (2003) Mime-Version in email header (1997) Redirect from Domain1 to Domain2 (2004) Forms Search Questions (1997) Playin Tricks (2006) Unsubscribe me (2001) Don't tick me off :) [elaspedtime] (1997) Location of Webcat site in folder hierarchy (1997) Signal Raised Error (1997) formatting dates from a field ... (1997) WebCat vs MS SiteServer? (1999) Rams SuperBowl Champs (2000) REPLACE problem (2000)