Re: Sorting error
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13462
interpreted = N
texte = Just for clarity it might be good to prepend as (ascending) to theYRsort, MTHsort, DYsort (asYRsort etc.) so the direction is clear. Second,in addition to viewing the titles, view the YR, MTH, DY fields with eachrecord - how are they sorted? Your WebDNA looks fine.John.>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?>>Michael>>Michael 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/John A. Hill Pacific Coast Software11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT *San Diego, CA 92128 http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
Just for clarity it might be good to prepend as (ascending) to theYRsort, MTHsort, DYsort (asYRsort etc.) so the direction is clear. Second,in addition to viewing the titles, view the YR, MTH, DY fields with eachrecord - how are they sorted? Your WebDNA looks fine.John.>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?>>Michael>>Michael 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/John A. Hill Pacific Coast Software11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT *San Diego, CA 92128 http://www.smithmicro.com
John Hill
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:
Talk List Suggestions (1997)
File Upload (1997)
Using the sendmail command on CGate Pro (Unix) (2000)
RE: Help name our technology! (1997)
PIXO support (1997)
Laying an egg. (1998)
IE Cache Problems... (1999)
[isfile] ? (1997)
[WebDNA] Problem with Cookies in IE and Safari (2009)
Weird WebCatalog problems (1998)
[url] with frames (2003)
Document Contains No Data! (1997)
auto-stripping of spaces (1997)
Unexpected error (1997)
WebDNA Server Spec (2004)
CC and Europe (1999)
WebCatalog Started!! Now What?? (2000)
SendMail on OS X (2003)
RAM variables (1997)
back button loses cart (2000)