Re: Sorting error

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13464
interpreted = N
texte = >When I sort the same way using WebCat (below), I get a seemingly random >order (#6, #8, #5, #9, ...) The sorted order doesn't even match the order >of records in the database.>[SEARCH >db=DB/Test.db&bwtitledata=Will&allhit=1&YRsort=1&MTHsort=2&DAYsort=3&YRtype=num >& >MTHtype=num&DAYtype=num] >[FOUNDITEMS] >[TITLE] ([MTH]/[DAY]/[YR])
>[/FOUNDITEMS] >[/SEARCH]Okay, first take the allhit parameter out of there. If you're sorting any other way that alphabetically, the allhit parameter will probably conflict with your 'other' sorting parameters. Try this instead, it should work:[SEARCH db=DB/Test.db&bwtitledata=Will&asYRsort=1&YRtype=num&asMTHsort=2&MTHtype=num&asD AYsort=3&DAYtype=num]Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting error (John Hill 1997)
  2. Re: Sorting error (Kenneth Grome 1997)
  3. Re: Sorting error (Michael Winston 1997)
  4. RE: Sorting error (Marc Eagle 1997)
  5. Re: Sorting error (Michael Winston 1997)
  6. Re: Sorting error (Michael Winston 1997)
  7. Re: Sorting error (John Hill 1997)
  8. Sorting error (Michael Winston 1997)
  9. Re: Sorting error (Kenneth Grome 1997)
  10. Re: Sorting error (Kenneth Grome 1997)
  11. Re: Sorting error (John Hill 1997)
>When I sort the same way using WebCat (below), I get a seemingly random >order (#6, #8, #5, #9, ...) The sorted order doesn't even match the order >of records in the database.>[SEARCH >db=DB/Test.db&bwtitledata=Will&allhit=1&YRsort=1&MTHsort=2&DAYsort=3&YRtype=num >& >MTHtype=num&DAYtype=num] >[founditems] >[TITLE] ([MTH]/[DAY]/[YR])
>[/FOUNDITEMS] >[/SEARCH]Okay, first take the allhit parameter out of there. If you're sorting any other way that alphabetically, the allhit parameter will probably conflict with your 'other' sorting parameters. Try this instead, it should work:[SEARCH db=DB/Test.db&bwtitledata=Will&asYRsort=1&YRtype=num&asMTHsort=2&MTHtype=num&asD AYsort=3&DAYtype=num]Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html 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:

[WebDNA] new list (2008) Emailer and encryption (1997) Is this possible, WebCat2.0 and checkboxes (1997) Sorting Numbers (1997) Re:2nd WebCatalog2 Feature Request (1996) RE: major search problem (1998) Dreamweave MX/WebDNA (2003) Database formats (2003) [WebDNA] WebDNA 8.6.4 (2020) Re1000001: Setting up shop (1997) SASL Support in WebDNA (2004) RequiredFields template (1997) taxTotal, too (1997) Security Levels... Possible? (2000) multiple search commands (1997) Using WC for Bulk Emailings (1997) WebSTAR plugin update (2004) Re[2]: Support suggestions - long (was politeness, et al) (2000) protect tag on NT IIS (1997) Page Counters? (1997)