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:

notification solutions (1997) pictures / referrer etc. (1998) External Images (1998) Unix line endings (2003) Basics of tcpconnect (2006) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) RE: Checkboxes to add to cart... (1998) Cookies (1999) Re:Merging databases (1997) can WC render sites out? (1997) Search design (1997) Multiple catalog databases and showcart (1997) Fed Ex Rate Charts (2003) One other big addition... (1997) Possible Bug in 2.0b15.acgi (1997) displaying New products (using [date]) (1997) Problems with [Search] param - Mac Plugin b15 (1997) RAM variables (1997) WebCatalog and Webstar 3.02 (1998) Exclamation point (1997)