Sorting error
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13468
interpreted = N
texte = I have yet *another* problem, this one with sorting my search results.For the sake of simplicity (and trying to isolate any errors), I've createda 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 toPower #1, Will to Power #2, etc.). MTH, DAY, and YR are all numericvalues that, when sorted by YR, then MTH, then DAY in Excel, give me theorder 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 randomorder (#6, #8, #5, #9, ...) The sorted order doesn't even match the orderof records in the database.[SEARCHdb=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]Is this a bug, or have I misread the docs?MichaelMichael Winston *By Phone!: (503)/652/8815 x341Internet Coordinator *By e-mail!: michaelw@dhorse.comDark Horse Comics, Inc. *By web!: http://www.dhorse.com/
Associated Messages, from the most recent to the oldest:
I have yet *another* problem, this one with sorting my search results.For the sake of simplicity (and trying to isolate any errors), I've createda 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 toPower #1, Will to Power #2, etc.). MTH, DAY, and YR are all numericvalues that, when sorted by YR, then MTH, then DAY in Excel, give me theorder 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 randomorder (#6, #8, #5, #9, ...) The sorted order doesn't even match the orderof records in the database.[SEARCHdb=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]Is this a bug, or have I misread the docs?MichaelMichael Winston *By Phone!: (503)/652/8815 x341Internet Coordinator *By e-mail!: michaelw@dhorse.comDark Horse Comics, Inc. *By web!: http://www.dhorse.com/
Michael Winston
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:
browser info.txt and SSL (1997)
[WriteFile] problems (1997)
WebCat hosting providers? - one more option (1997)
Header values are not accepted (1998)
Mac v. NT (1998)
WebCat2final1 crashes (1997)
New public beta available (1997)
forming a SKU (1999)
[WebDNA] Successful, working WebDNA7/CentOS install? (2013)
Javascript and Search Results (1998)
WebCat2b12--[searchstring] bug (1997)
syntax question, not in online refernce (1997)
Download URL & access on the fly ? (1997)
WebCatalog2 for NT Beta Request (1997)
Document Contains No Data! (1997)
wierd [cart] action! (1997)
PCS Frames (1997)
Configuring E-mail (1997)
WebDNA 5.1 & public CMS (2003)
Interfacing WebMerchant to www.fedex.com (1997)