Re: [WebDNA] search by range of dates
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103996
interpreted = N
texte = > Hi Terry, I've read the docs you've mentioned. Thank you.> I've tried your suggestions, along with a dozen other variations, > and I either get all the records returned, or no records returned.> This is the current code which returns no records. Am I setting the > TENDAYSAGO variable wrong? It looks correct on my screen.>> [text]TENDAYSAGO=[math date]{[date]}-10[/math][/text] > TENDAYSAGO=[TENDAYSAGO]
> [search db=assign_events/ > temp > .db > &grSKUPdata > =0&FORMATTED_DATEtype=date&rnFORMATTED_DATEdatarq=[TENDAYSAGO] [date]]>> I get every past record returned if I use {[TENDAYSAGO]}.> At least it not giving me future dated records anymore.>> Thanks again,> sfbdid you try using the mr & xr comparison operators as I suggested? There were a couple of times that I could not get my searches to work with ranges any other way, ... despite that other methods (as per docs) *should* have worked.------------Govindagovinda.webdnatalk@gmail.com
Associated Messages, from the most recent to the oldest:
> Hi Terry, I've read the docs you've mentioned. Thank you.> I've tried your suggestions, along with a dozen other variations, > and I either get all the records returned, or no records returned.> This is the current code which returns no records. Am I setting the > TENDAYSAGO variable wrong? It looks correct on my screen.>>
[text]TENDAYSAGO=[math date]{
[date]}-10[/math][/text] > TENDAYSAGO=[TENDAYSAGO]
> [search db=assign_events/ > temp > .db > &grSKUPdata > =0&FORMATTED_DATEtype=date&rnFORMATTED_DATEdatarq=[TENDAYSAGO]
[date]]>> I get every past record returned if I use {[TENDAYSAGO]}.> At least it not giving me future dated records anymore.>> Thanks again,> sfbdid you try using the mr & xr comparison operators as I suggested? There were a couple of times that I could not get my searches to work with ranges any other way, ... despite that other methods (as per docs) *should* have worked.------------Govindagovinda.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:
How do I get Google to crawl a WebCat site? (2003)
Updated ClipText for Edit Plus 2 (2003)
Encypt Question - Making New Users.db (1999)
[Protect] tag NOT working in 4.01 with Webstar 4.2 ! (2000)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
WebCatalog f2 Installation (1997)
[WebDNA] Extracting contents of a div (2012)
Searching a field and returning the highest value (1997)
Slow [spawn] (2003)
Quantity * price (1997)
Emailer (WebCat2) (1997)
WebDNA on Redhat (2008)
Locking up with WebCatalog... (1997)
Cookie set browser session. (1998)
European Convention (2004)
Understanding texta (1997)
can WC render sites out? (1997)
no country? (1998)
[WebDNA] Carriage Return/Line Feed Issue (2009)
Newbie question (1999)