RE: Sorting error
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13474
interpreted = N
texte = Michael ->For the sake of simplicity (and trying to isolate any errors), I've created >a small database with 5 fields (sku, title, mth, day, yr) and 12 records >(all of which have titles that start with Will to Power, like Will to >Power #1, Will to Power #2, etc.). MTH, DAY, and YR are all numeric >values that, when sorted by YR, then MTH, then DAY in Excel, give me the >order that I want (Will To Power #1 first, Will to Power #12 last). >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]I can see the same problem here. I'm not sure what's going on, but if you'd like to work around it in the meantime, try replacing all the 1-digit values in the MTH and DAY fields with 2-digit values (so that '2' becomes '02' -- you can do a replace that searches for values less than 10 and replaces them with '0[mth]' or '0[day]'). Remove the '&MTHtype=num&DAYtype=num' parameters from your search and everthing should sort correctly. If you want the output to look like '2/8/1997', just change the text in the [founditems] context to ([math][MTH][/math]/[math][DAY][/math]/[YR]).Hope this helps for now,Marc Eagle StarNine Technologies http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Michael ->For the sake of simplicity (and trying to isolate any errors), I've created >a small database with 5 fields (sku, title, mth, day, yr) and 12 records >(all of which have titles that start with Will to Power, like Will to >Power #1, Will to Power #2, etc.). MTH, DAY, and YR are all numeric >values that, when sorted by YR, then MTH, then DAY in Excel, give me the >order that I want (Will To Power #1 first, Will to Power #12 last). >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]I can see the same problem here. I'm not sure what's going on, but if you'd like to work around it in the meantime, try replacing all the 1-digit values in the MTH and DAY fields with 2-digit values (so that '2' becomes '02' -- you can do a replace that searches for values less than 10 and replaces them with '0[mth]' or '0[day]'). Remove the '&MTHtype=num&DAYtype=num' parameters from your search and everthing should sort correctly. If you want the output to look like '2/8/1997', just change the text in the
[founditems] context to (
[math][MTH][/math]/
[math][DAY][/math]/[YR]).Hope this helps for now,Marc Eagle StarNine Technologies http://www.smithmicro.com/
Marc Eagle
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:
Showif, Hideif reverse logic ? (1997)
createfolder default behavior (1998)
getchars broken? (1997)
Passing [quantity] (2000)
Running _every_ page through WebCat-error.html (1997)
[BoldWords] WebCat.acgib15Mac (1997)
practicing safe queries.. (2000)
Re1000002: Setting up shop (1997)
Date search bug (1997)
OT: Poll Results (2002)
Can't Update records (1997)
[addlineitems] display (1997)
syntax question, not in online refernce (1997)
Changes to [ReturnRaw] in 3.0 (1998)
WC2b12: Yes, Formulas.db is for real (1997)
Add a Blog to your site. (2002)
Plugin or CGI or both (1997)
Question (1998)
[WebDNA] v7.x [thisurl] (2010)
Roundup function? (1997)