Re: Date Range Search not working
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34887
interpreted = N
texte = >The code below doesn't find anything. Do I need brackets around the >[date] and [t_lwdate]?>>[!]Set up variable that is for the date a week ago[/!]>[TEXT]t_lwdate=[Math date]{[date]}-7[/Math][/TEXT]>>[search >db=bulletins.db&eqLISTNAMEdatarq=[blist]&rnCDATEdatarq=[date] >[t_lwdate]&CDATEtype=date&TOPICsort=1&SKUsort=2&TOPICsdir=de]No, you have to put the oldest date first. Searches using rn always fail unless the smallest or earliest or 'first' value actually comes first.================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>The code below doesn't find anything. Do I need brackets around the >[date] and [t_lwdate]?>>[!]Set up variable that is for the date a week ago[/!]>[text]t_lwdate=[Math date]{[date]}-7[/Math][/TEXT]>>[search >db=bulletins.db&eqLISTNAMEdatarq=[blist]&rnCDATEdatarq=[date] >[t_lwdate]&CDATEtype=date&TOPICsort=1&SKUsort=2&TOPICsdir=de]No, you have to put the oldest date first. Searches using rn always fail unless the smallest or earliest or 'first' value actually comes first.================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Kenneth Grome
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:
SSL Certificates (2004)
ImageMagick Commands? (2003)
OT: Need some feedback, please. (2003)
Answer: WebDelivery downloads alias, not original ? (1997)
Replace context problem ... and answers (1997)
Multiple prices (1997)
Show shoppingcart after remove last item (1997)
Emailer setup (1997)
Thanks... (1999)
Setting up shop (1997)
Logging purchases (1997)
Re1000001: Setting up shop (1997)
Single Link browsing (1997)
Spellcheck (2003)
Unix line endings (2003)
[table] question (2007)
Nested [SEARCH] and [REPLACE] problem. (1997)
Shopping Cart - prices? (1997)
Price problem (1997)
bug in Webcat OSX (1999)