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 high 1 100 30 300 50 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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (PCS Technical Support 1999)
  2. Re: BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (PCS Technical Support 1999)
  3. Re: BUG REPORT: numeric ge, le, gr & ls comparisons don't work (Brian B. Burton 1999)
  4. Re: BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (Kenneth Grome 1999)
  5. Re: BUG REPORT: numeric ge, le, gr & ls comparisons don't work... (PCS Technical Support 1999)
  6. 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 high 1 100 30 300 50 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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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:

re: Large Database Options? (1999) multiple databases (1997) typhoon... (1997) switching users (1998) Help name our technology! I found it (1997) billing system (2003) No incentive ... (2000) RE: Error reading data -1 (1997) pc (1997) block serving .db files (2002) using webdna to determine pixel parameters (2000) Location of Browser Info.txt file (1997) Trouble with Netscape (1998) [WebDNA] find missing file in [listfiles] (2019) TCPConnect & TCPSend (2003) To Err or Not Custom Error (1999) [SHOWIF AND/OR] (1997) NT Processor Woes (2000) WebCatalog for guestbook ? (1997) WebCat2b15MacPlugin - showing [math] (1997)