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:
Superfilous Characters (1998)
what servers are supported for Typhoon? (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Field name-subcategory (1997)
grep is really pathetic sometimes (2003)
WebCat2 beta 11 - new prefs ... (1997)
FoxPro & WebDNA (2006)
includes and cart numbers (1997)
Navigator 4.01 (1997)
two unique banners on one page (1997)
PIXO support (1997)
Emails are Stuck (2003)
Shopping carts and reloading pages (1997)
Need relative path explanation (1997)
WebCat2 several catalogs? (1997)
customizing the color of user's pages (1997)
Truncated text (2006)
[WebDNA] WebDNA 7 multiple fcgid processes (2012)
[WebDNA] [BULK] The WebDAV Server Module / web services (2012)
PCS Emailer's role ? (1997)