Re: oddball sorting problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 55044
interpreted = N
texte = Have you tried declaring the order? [search ...date1type=date&gedate1datarq=[date]&asdate1sort=1&asdate2sort=2] that sort of thing? RonnyMc ----- Original Message ----- From: "Terry Wilson" To: "WebDNA Talk" Sent: Wednesday, December 17, 2003 8:22 PM Subject: oddball sorting problem > I have this: > > [search > ....group1field=date1+date2&group1type=date&gegroup1datarq=[date]&date1type=d ate&date1sort=1] > > I originally had this: > > [search ...date1type=date&gedate1datarq=[date]&date1sort=1] > > The original search returned the records in the ascending order that > I expected. When I altered it to include a second date (some events > might have two dates), now it sorts screwy. Events with two dates > float to the top (sorted correctly if both dates meet the ge > criterion), followed by double dates where one date meets the > requirement, and finally, the single date items (again, sorted > correctly). What is causing the two-date items to precede the others? > > Maybe a clarification of what exactly is happening with grouped > fields will help. > > I have it roughed out at http://terryfic.com/~yardsales/ > > Feel free to play with it. It will be up for a few more days as I develop it. > > Thanks, > Terry > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: oddball sorting problem ( Terry Wilson 2003)
  2. Re: oddball sorting problem [feature request] ( Donovan Brooke 2003)
  3. Re: oddball sorting problem ( Brian Fries 2003)
  4. Re: oddball sorting problem ( Terry Wilson 2003)
  5. Re: oddball sorting problem ( Donovan Brooke 2003)
  6. oddball sorting problem -- almost okay now ( Terry Wilson 2003)
  7. Re: oddball sorting problem ( Tim Robinson 2003)
  8. Re: oddball sorting problem ( "WebDna @" 2003)
  9. oddball sorting problem ( Terry Wilson 2003)
Have you tried declaring the order? [search ...date1type=date&gedate1datarq=[date]&asdate1sort=1&asdate2sort=2] that sort of thing? RonnyMc ----- Original Message ----- From: "Terry Wilson" To: "WebDNA Talk" Sent: Wednesday, December 17, 2003 8:22 PM Subject: oddball sorting problem > I have this: > > [search > ....group1field=date1+date2&group1type=date&gegroup1datarq=[date]&date1type=d ate&date1sort=1] > > I originally had this: > > [search ...date1type=date&gedate1datarq=[date]&date1sort=1] > > The original search returned the records in the ascending order that > I expected. When I altered it to include a second date (some events > might have two dates), now it sorts screwy. Events with two dates > float to the top (sorted correctly if both dates meet the ge > criterion), followed by double dates where one date meets the > requirement, and finally, the single date items (again, sorted > correctly). What is causing the two-date items to precede the others? > > Maybe a clarification of what exactly is happening with grouped > fields will help. > > I have it roughed out at http://terryfic.com/~yardsales/ > > Feel free to play with it. It will be up for a few more days as I develop it. > > Thanks, > Terry > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "WebDna @"

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:

BBEdit and WebCatalog 2.0? (1997) Writing encrypted files causes errors ... (1998) security problem (1997) WebCatalog2 Feature Feedback (1996) Caching pages...again (2001) First postarg not taking in $Commands (1997) Banners (1997) WebCat2 - Getting to the browser's username/password data (1997) Semi [OT]: Clustering for Apache/MySQL on OS X (2004) WCS Newbie question (1997) Claris HomePage messes up the code (1997) WebCatalog can't find database (1997) Follow-Up to: Removing [showif] makes a big difference in speed (1997) Admin Edit prob. (1997) appleshare/ip (1997) Error in searchable archives (2002) Progress !! WAS: Trouble with formula.db (1997) WebDNA 6 (2004) WebCat for mass emailings (1997) Sorting search by date. (2000)