Re: [WebDNA] search by range of dates
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103991
interpreted = N
texte = > Thanks Stuart, your help made sense, so I added it, but it's still > not working for me. > I'm trying to return only the records within the preceding 10 days. > here's my code, the field name is FORMATTED_DATE: > > [text]TENDAYSAGO=[math date]{[date]}-10[/math][/text] > [search db=/ > temp > .db > &grSKUdata > = > 0 > &FORMATTED_DATEtype > =date&TENDAYSAGOtype=date&leFORMATTED_DATEdatarq=[date][!] > [/!]&geFORMATTED_DATEdata=[TENDAYSAGO]&deFORMATTED_DATEsort=1] > > Any ideas for me? Thanks, > sfb I always had better luck using the range comparison operators over the greater/less than ones. try this: [search db=/ temp .db &grSKUdata = 0 &FORMATTED_DATEtype =date&TENDAYSAGOtype=date&xrFORMATTED_DATEdatarq=[date][!] [/!]&mrFORMATTED_DATEdatarq=[TENDAYSAGO]&deFORMATTED_DATEsort=1] ----------------- if still no luck then: (just some ideas) - make sure everything is even evaluating the way you think it is.. put this is in your page and see what it looks like when you hit it: - -also what is [numfound] showing? - How are you determining that the search is failing? - are the values in the temp.db for the [FORMATTED_DATE] field in the same date format as what you have told your server is the default [date] format? ------------ Govinda govinda.webdnatalk@gmail.com
Associated Messages, from the most recent to the oldest:
> Thanks Stuart, your help made sense, so I added it, but it's still > not working for me. > I'm trying to return only the records within the preceding 10 days. > here's my code, the field name is FORMATTED_DATE: > >
[text]TENDAYSAGO=[math date]{
[date]}-10[/math][/text] > [search db=/ > temp > .db > &grSKUdata > = > 0 > &FORMATTED_DATEtype > =date&TENDAYSAGOtype=date&leFORMATTED_DATEdatarq=
[date][!] > [/!]&geFORMATTED_DATEdata=[TENDAYSAGO]&deFORMATTED_DATEsort=1] > > Any ideas for me? Thanks, > sfb I always had better luck using the range comparison operators over the greater/less than ones. try this: [search db=/ temp .db &grSKUdata = 0 &FORMATTED_DATEtype =date&TENDAYSAGOtype=date&xrFORMATTED_DATEdatarq=
[date][!] [/!]&mrFORMATTED_DATEdatarq=[TENDAYSAGO]&deFORMATTED_DATEsort=1] ----------------- if still no luck then: (just some ideas) - make sure everything is even evaluating the way you think it is.. put this is in your page and see what it looks like when you hit it: - -also what is [numfound] showing? - How are you determining that the search is failing? - are the values in the temp.db for the [FORMATTED_DATE] field in the same date format as what you have told your server is the default
[date] format? ------------ Govinda govinda.webdnatalk@gmail.com
Govinda
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:
Re:no [search] with NT (1997)
[OT] Gateway and Merchant Fees! (2006)
OLD ORDERS (1998)
Using Plug-In while running 1.6.1 (1997)
Re[2]: Re[2]: WebCatalog on Linux (2000)
authorizenet and netscape (2002)
errormessages.db (1997)
[WebDNA] Conversion of 500.000 records; advise needed (2008)
[WebDNA] JSONobject (2020)
system crashes, event log (1997)
Mozilla/4. and Browser Info.txt (1997)
calculating tax rates, mail order solutions and version 2 (1997)
[append] (1997)
Post arguments problem mac? (1997)
5.0 Pricing (2003)
[showif]/[hideif] question (1997)
need help with [sendmail] and [showif]s (1998)
emailer (1997)
Generating unique SKU from [cart] - Still Stumped... (1997)
Multiple Merchant Accounts? (1997)