Re: Problem with date and ranges

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 45816
interpreted = N
texte = Nitai,On Friday, November 29, 2002, at 06:09 PM, 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]Just to verify, on the search page, you are converting the user entered dates to number of days, to match what you said is stored in the db right?So if the form field is [start] you are doing [math show=f]startdate=[math]{[start]}[/math][/math]and the same for the end date, right? Just to make sure you are searching on the same format data. From then I would try a range search. Although in previous versions of WebCat (3.0 on Mac) it didn't work properly. Not sure it if has been fixed by now or not.> All dates are stored as numbers and are shown here for easier reading as> dates.>> Any help very much appreciated.>> Sincerely> Nitai Aventaggiato> CEODale-------------------------------------------------------------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:

Re: Problem with date and ranges (Gary Krockover 2002)
Re: Problem with date and ranges (dale's stuff 2002)
Re: Problem with date and ranges (sally 2002)
Re: Problem with date and ranges (Glenn Busbin 2002)
Re: Problem with date and ranges (WJ Starck 2002)
Problem with date and ranges (Nitai @ ComputerOil 2002)

Nitai,On Friday, November 29, 2002, at 06:09 PM, 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]Just to verify, on the search page, you are converting the user entered dates to number of days, to match what you said is stored in the db right?So if the form field is [start] you are doing [math show=f]startdate=[math]{[start]}[/math][/math]and the same for the end date, right? Just to make sure you are searching on the same format data. From then I would try a range search. Although in previous versions of WebCat (3.0 on Mac) it didn't work properly. Not sure it if has been fixed by now or not.> All dates are stored as numbers and are shown here for easier reading as> dates.>> Any help very much appreciated.>> Sincerely> Nitai Aventaggiato> CEODale-------------------------------------------------------------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/ dale's stuff

DOWNLOAD WEBDNA NOW!

Re: Problem with date and ranges

2002

Top Articles:

Related Readings: