Re: Sorting error

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13469
interpreted = N
texte = The next test would be to sort the years by themselves, months by themselves, then days by themselves: do they sort as expected. Next sort just by year and month: does that work as expected. Maybe in doing this something will become clearer. John. >>>>At 1:02 PM -0800 9/16/97, John Hill is rumored to have typed:> Just for clarity it might be good to prepend as (ascending) to the> YRsort, MTHsort, DYsort (asYRsort etc.) so the direction is clear. Second,> in addition to viewing the titles, view the YR, MTH, DY fields with each> record - how are they sorted? Your WebDNA looks fine. I've added as (I thought I had to put it in a different arguement like YRsdir=as. I like this new way better). So, with the WebDNA:[SEARCH db=DB/Test.db&bwtitledata=Will&allhit=1&asYRsort=1&asMTHsort=2&asDAYsort=3&YRtype=num&MTHtype=num&DAYtype=num][FOUNDITEMS][TITLE] ([MTH]/[DAY]/[YR])<
[/FOUNDITEMS][/SEARCH] I get:Will to Power #9 (8/2/94)Will to Power #11 (8/4/94)Will to Power #5 (7/2/94)Will to Power #8 (8/1/94)Will to Power #6 (7/3/94)Will to Power #4 (7/1/94)Will to Power #10 (8/3/94)Will to Power #2 (6/2/94)Will to Power #1 (6/1/94)Will to Power #3 (6/3/94)Will to Power #7 (7/4/94) MichaelMichael Winston *By Phone!: (503)/652/8815 x341Internet Coordinator *By e-mail!: michaelw@dhorse.comDark 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:

    
  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)
The next test would be to sort the years by themselves, months by themselves, then days by themselves: do they sort as expected. Next sort just by year and month: does that work as expected. Maybe in doing this something will become clearer. John. >>>>At 1:02 PM -0800 9/16/97, John Hill is rumored to have typed:> Just for clarity it might be good to prepend as (ascending) to the> YRsort, MTHsort, DYsort (asYRsort etc.) so the direction is clear. Second,> in addition to viewing the titles, view the YR, MTH, DY fields with each> record - how are they sorted? Your WebDNA looks fine. I've added as (I thought I had to put it in a different arguement like YRsdir=as. I like this new way better). So, with the WebDNA:[SEARCH db=DB/Test.db&bwtitledata=Will&allhit=1&asYRsort=1&asMTHsort=2&asDAYsort=3&YRtype=num&MTHtype=num&DAYtype=num][founditems][TITLE] ([MTH]/[DAY]/[YR])<
[/FOUNDITEMS][/SEARCH] I get:Will to Power #9 (8/2/94)Will to Power #11 (8/4/94)Will to Power #5 (7/2/94)Will to Power #8 (8/1/94)Will to Power #6 (7/3/94)Will to Power #4 (7/1/94)Will to Power #10 (8/3/94)Will to Power #2 (6/2/94)Will to Power #1 (6/1/94)Will to Power #3 (6/3/94)Will to Power #7 (7/4/94) MichaelMichael Winston *By Phone!: (503)/652/8815 x341Internet Coordinator *By e-mail!: michaelw@dhorse.comDark 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:

Tab Charactor (1997) Cookies [was How do I get Google to crawl a WebCat site?] (2003) Errata: WCS Newbie question (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) 5.0 Pricing (2003) Calculate QTY (1998) [WebDNA] "The requested URL" error not allowing access to site... (2014) Max Include levels (2000) WebCatalog Hosting (1996) Automatic Download? (2003) Smart caching problems with 2.1b3? (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) simple answer? [hideif] (1997) Beta (?) version of WebCatalog 2.1 (1998) Ok here is a question? (1997) docs for WebCatalog2 (1997) Is there an alternative to emailer? (1999) WebCat B13 Mac CGI -- Frames question (1997) Simple way to create unique SKU (1997) 2.0 Info (1997)