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:

RE: protect tag on NT (1997) [OT] DNS server swap (2003) wierd [cart] action! (1997) [searchString] (1997) Some cool tools as well (2002) Crazy dates (was: sorting dates) (1999) showing *all* name/value pairs with [search] (2003) Download URL & access on the fly ? (1997) MacAuthorize order data fields WAS:How To question... (1997) Include a big block of text (1997) Frames and WebCat (1997) WebCat on Linux (2000) Problem displaying search result (1997) What is WebDNA (1997) WebCommerce: Folder organization ? (1997) WebCat2b13 Command Reference Doc error (1997) Updating Prices in DB (working) (1999) date pref (1999) Oops, Sorry for the cluttter ... Looking for WebCatdeveloper/contractor (2000) Search/sort in URL Was: GuestBook example (1997)