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:
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:
serial number generation (1997)
Robots fill event log (1997)
Search Context: How to set Max=N? (2000)
system crashes, event log (1997)
Sorting error (1997)
New Command prefs ... (1997)
psst (1997)
update on include (1997)
Items XX to XX shown (1997)
Writefile (2000)
[ModDate] & [ModTime] ? (1997)
OBDC Support (1997)
flushdatabases (1997)
Email Newsletters (2003)
Post Limits (1998)
To Use Cookies or Not To Use Cookies (2003)
E-Mailer (WebCatb15acgiMac) (1997)
WC1.6 to WC2 date formatting (1997)
[WebDNA] Another strange WebDNA problem (2013)
[/application] error? (1997)