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:

WebSTAR 2.1 freezes my Mac (1997) Associative lookup style? + bit more (1997) WebCommerce: Folder organization ? (1997) greater than or equal to (1997) [founditems][replacefounditems] (2003) [include] error message (was:how to put/keep product customization info in basket?) (1998) UPS Shipping Calculations (2001) Help (1999) WebCatalog plugin, FireSite and PIXO (2000) Server crashes when user saves or views html source (1998) [WebDNA] [announce] WebDNA 6.2.1x (2012) Passing a search through a form (2003) WebDNA Server Not Running (2005) Unexpected error (1997) [searchString] (1997) WC2f3 (1997) Text limits in NT version? (1997) Deleting Orders (1997) [WebDNA] Processor Maxing out (2010) WebCatalog Hosting (1996)