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 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]Is this a bug, or have I misread the docs?MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ 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)
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 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]Is this a bug, or have I misread the docs?MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark 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)