BUG REPORT: numeric ge, le, gr & ls comparisons don't work ...
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22276
interpreted = N
texte = Using numeric ge, le, gr & ls comparisons in a search context fail, but using the opposite comparison gives the correct results when it should fail. This means webcat is working just the opposite of how it should work. Try it for yourself with the following test.db and test.tpl page and you'll see what I mean ...Test.db:low high1 10030 30050 500Test.tpl:[search db=test.db&gelowdatarq=[value]&lehighdatarq=[value]&lowtype=num&hightype=num]Correct Code finds [numfound] matches:
[founditems][low]-[high]
[/founditems][/search]
[search db=test.db&lelowdatarq=[value]&gehighdatarq=[value]&lowtype=num&hightype=num]Incorrect Code finds [numfound] matches:
[founditems][low]-[high]
[/founditems][/search]
Done.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
|
- Re: BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (PCS Technical Support 1999)
- Re: BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (PCS Technical Support 1999)
- Re: BUG REPORT: numeric ge, le, gr & ls comparisons don't work (Brian B. Burton 1999)
- Re: BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (Kenneth Grome 1999)
- Re: BUG REPORT: numeric ge, le, gr & ls comparisons don't work... (PCS Technical Support 1999)
- BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (Kenneth Grome 1999)
|
Using numeric ge, le, gr & ls comparisons in a search context fail, but using the opposite comparison gives the correct results when it should fail. This means webcat is working just the opposite of how it should work. Try it for yourself with the following test.db and test.tpl page and you'll see what I mean ...Test.db:low high1 10030 30050 500Test.tpl:[search db=test.db&gelowdatarq=[value]&lehighdatarq=[value]&lowtype=num&hightype=num]Correct Code finds [numfound] matches:
[founditems][low]-[high]
[/founditems][/search]
[search db=test.db&lelowdatarq=[value]&gehighdatarq=[value]&lowtype=num&hightype=num]Incorrect Code finds [numfound] matches:
[founditems][low]-[high]
[/founditems][/search]
Done.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:
Webten + Webcat running smooth (1998)
log files (1998)
[SearchString] usage (1997)
mac os HOG? (2001)
WebDNA Solutions ... sorry! (1997)
[WebDNA] [OT] WebDNA Payment Processing Integration Recommendations? (2011)
WebCat2b12--[searchstring] bug (1997)
Big Databases (1997)
Need relative path explanation (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
Nested tags count question (1997)
Max Record length restated as maybe bug (1997)
test (2007)
pulling URL information (2003)
Merchant and WebCat 3.0 (1998)
[carts] and databases (1997)
Mac: LModelDirector bug fix (1997)
Quotes inside alt tags (2008)
showif comparison begins w/ and contains (1997)
[taxRate] [TaxTotal] ? (1997)