Re: Sorting error
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13486
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.>>In all cases, the first sort works fine (sort=1) but the it breaks>down at the second sort (sort=2).>>However, if I first sort by YR and then by TITLE, both sorts work fine.>The sort also works if I remove the type=num args, but it'll break>down when it reaches 2-digit numbers.>So the trouble seems come from sorting more than one field that has type=num.Interesting concept ... but why do you have to have your dates splitup into three different parts anyways?I've been wondering about this since you posted your first message,but I didn't ask before. May be there's a way around whatever 'other'problems you're dealing with that would allow you to keep the datesintact instead of splitting them up into several different fields.Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
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.>>In all cases, the first sort works fine (sort=1) but the it breaks>down at the second sort (sort=2).>>However, if I first sort by YR and then by TITLE, both sorts work fine.>The sort also works if I remove the type=num args, but it'll break>down when it reaches 2-digit numbers.>So the trouble seems come from sorting more than one field that has type=num.Interesting concept ... but why do you have to have your dates splitup into three different parts anyways?I've been wondering about this since you posted your first message,but I didn't ask before. May be there's a way around whatever 'other'problems you're dealing with that would allow you to keep the datesintact instead of splitting them up into several different fields.Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
Kenneth Grome
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:
QuantityPrice computed? (1998)
[WebDNA] Seriously what is wrong here? (2011)
My new discussion forum (2003)
Navigator 4.0 & tables (1997)
Sorting by date (1997)
showif and cart (1997)
Security Issue (1999)
Date or time comparisons have bugs ... (1998)
WebCat B13 Mac CGI -- Frames question (1997)
RE: type 2 errors with ssl server (1997)
RE: Which [index]? (1997)
Summing fields (1997)
Formating found categories (1997)
b12 cannot limit records returned and more. (1997)
[WebDNA] v7 Stress Test and Strange Behaviour (2012)
E-mailer error codes (1997)
Template Security error (1997)
Country & Ship-to address & other fields ? (1997)
Email Problem (1997)
Re1000001: Setting up shop (1997)