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:
[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)