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:

Help name our technology! (1997) Search Title Question (1998) [WebDNA] WebDNA future (2010) verify online (1997) breaking words (1997) simple answer? [hideif] (1997) AppleScript question (1997) creating a ShipCosts database (1997) Mac app. that converts e-mails (2000) [WebDNA] [OT] File structure for purchased downloads (2010) docs for WebCatalog2 (1997) SOP for WebDNA talk (2004) limitation found on group searching (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Here we go again... was: DDEConnect not working (2006) form posts expiring instantly... why? (2000) This may make you do a double take (2004) Message Board (1998) Multi-processor Mac info ... (1997) two unique banners on one page (1997)