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:
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)