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,-WillOn 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:
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,-WillOn 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)