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 sortingany other way that alphabetically, the allhit parameter will probablyconflict with your 'other' sorting parameters. Try this instead, itshould work:[SEARCHdb=DB/Test.db&bwtitledata=Will&asYRsort=1&YRtype=num&asMTHsort=2&MTHtype=num&asDAYsort=3&DAYtype=num]Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
Associated Messages, from the most recent to the oldest:
>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 sortingany other way that alphabetically, the allhit parameter will probablyconflict with your 'other' sorting parameters. Try this instead, itshould work:[SEARCHdb=DB/Test.db&bwtitledata=Will&asYRsort=1&YRtype=num&asMTHsort=2&MTHtype=num&asDAYsort=3&DAYtype=num]Sincerely, Ken GromeWebDNA Solutionshttp://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)