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 split up 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 dates intact instead of splitting them up into several different fields.Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html 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. > >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 split up 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 dates intact instead of splitting them up into several different fields.Sincerely, Ken Grome WebDNA Solutions http://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:

WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997) AutoCommit Preference? (1998) WebCat2 - [SendNews] (1997) Off Topic: SNMP over TCP/IP (1998) WebCat.acgi from /cgi-bin/? (1997) Multiple prices (1997) Re:How to Display text in empty fields (1997) Time comparison question (1998) WebDNA Feature Request (2006) Secure Sever and showcart errors (1997) [ListFiles] & [loop] (1998) Help name our technology! I found it (1997) Re:WebCat Talk Arhives... (1998) Trouble with formula.db + more explanation (1997) RE: type 2 errors with ssl server (1997) permission deny help please (2004) DreamWeaver MX Bug (2002) RE: Languages (1997) WebCat for mass emailings (1997) [WebDNA] WebDNA & mySQL (2008)