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:

DON'T use old cart file! (1997) Zipcodes (1998) Pithy questions on webcommerce & siteedit (1997) WCS Newbie question (1997) Fun with Dates - finally resolved but.... (1997) Authenticate (1997) Protect (1997) WC2b15 File Corruption (1997) Not really WebCat (1997) [math] oddness .. (2002) displaying New products (Yikes! it's Fixed!) (1997) Not really WebCat- (1997) WebMerchant Mac 3.0 beta available (1998) Quick Data sorting questions (2002) Anyone have an invoicing system? (2000) [shownext] and sort (1998) Execute Applescript (1997) Never mind.... Searching blank fields problem (1999) Triggers (2005) WC TableGrinder (1997)