Re: rn doesn't work on date fields
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17444
interpreted = N
texte = >>Range searching does NOT work on date fields, it always give the wrong>>results. I had to change my code to use pairs of gr and ls parameters>>(on group fields) instead of using rn, because rn just doesn't work ...>>Maybe a search for date range at search.smithmicro.com will turn up>some helpful hints.Well, in fact my archive search *DID* turn up some helpful hints -- and one of those hints was a very thoughtful suggestion from Gary Richter to put this information into the docs so others could benefit from it:>It appears the smaller number must be in front and the larger>number in the back, no matter what the sort order.>>Maybe a note in the online docs for others to see.But this information never made it into the HTML docs, even though there's been at least one or maybe two doc revisions during the 4.5 months since Gary posted his request. So ... since I could not find it in the docs, I posted my request to this list.Please let me know when this range searching information, and the new rule about not using [delete] or [replace] inside looping contexts, and any other critical but as-yet undocumented information makes it into the next revision of the HTML docs, so I can start relying on that resource again.Thanks! :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>Range searching does NOT work on date fields, it always give the wrong>>results. I had to change my code to use pairs of gr and ls parameters>>(on group fields) instead of using rn, because rn just doesn't work ...>>Maybe a search for date range at search.smithmicro.com will turn up>some helpful hints.Well, in fact my archive search *DID* turn up some helpful hints -- and one of those hints was a very thoughtful suggestion from Gary Richter to put this information into the docs so others could benefit from it:>It appears the smaller number must be in front and the larger>number in the back, no matter what the sort order.>>Maybe a note in the online docs for others to see.But this information never made it into the HTML docs, even though there's been at least one or maybe two doc revisions during the 4.5 months since Gary posted his request. So ... since I could not find it in the docs, I posted my request to this list.Please let me know when this range searching information, and the new rule about not using
[delete] or
[replace] inside looping contexts, and any other critical but as-yet undocumented information makes it into the next revision of the HTML docs, so I can start relying on that resource again.Thanks! :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
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:
SET (1998)
WebDNA Intranet Edition release (2002)
View order not right (1997)
emailer and bad addresses (1997)
server2003 issue (OT) (2006)
Random Image (1998)
(2000)
WebCatalog/WebMerchant 2.1 (1998)
Search group and ww (2003)
RAW=T..Strange behaviour (2000)
[shell] oddity (2002)
triggers.db (1999)
Help name our technology! I found it (1997)
New site announcement + Showing once on a founditems (1997)
& in Lookups (1997)
using showpage and showcart commands (1996)
WebCat2 beta 11 - new prefs ... (1997)
Re:listfiles-looking for slick solution (1997)
verify online (1997)
Bookmarked URL with cart (1998)