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, > sfb did 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. ------------ Govinda govinda.webdnatalk@gmail.com Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] search by range of dates (sbraun 2009)
  2. Re: [WebDNA] search by range of dates (Govinda 2009)
  3. Re: [WebDNA] search by range of dates (Donovan Brooke 2009)
  4. Re: [WebDNA] search by range of dates (Govinda 2009)
  5. Re: [WebDNA] search by range of dates ("Terry Wilson" 2009)
  6. Re: [WebDNA] search by range of dates (sbraun 2009)
  7. Re: [WebDNA] search by range of dates (Stuart Tremain 2009)
  8. Re: [WebDNA] search by range of dates ("Terry Wilson" 2009)
  9. Re: [WebDNA] search by range of dates (Govinda 2009)
  10. Re: [WebDNA] search by range of dates (sbraun 2009)
  11. Re: [WebDNA] search by range of dates (Stuart Tremain 2009)
  12. [WebDNA] search by range of dates (sbraun 2009)
> 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, > sfb did 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. ------------ 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:

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)