Re: oddball sorting problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 55045
interpreted = N
texte = If you have field names of date1 and date2, then you don't need to use group1field. That's only if you want to use separate search parameters on the same field. Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837 > From: Terry Wilson > Reply-To: (WebDNA Talk) > Date: Wed, 17 Dec 2003 23:22:00 -0500 > To: (WebDNA Talk) > Subject: oddball sorting problem > > I have this: > > [search > ...group1field=date1+date2&group1type=date&gegroup1datarq=[date]&date1type=dat > e&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)
If you have field names of date1 and date2, then you don't need to use group1field. That's only if you want to use separate search parameters on the same field. Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837 > From: Terry Wilson > Reply-To: (WebDNA Talk) > Date: Wed, 17 Dec 2003 23:22:00 -0500 > To: (WebDNA Talk) > Subject: oddball sorting problem > > I have this: > > [search > ...group1field=date1+date2&group1type=date&gegroup1datarq=[date]&date1type=dat > e&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/ Tim Robinson

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:

Default admin bug and how tech support reacted to it. (2000) WC2/Mac -- Forms not submitting correctly with Mac browsers (1997) Closing Databases (1998) ACGI processing for .html (1997) WebCatalog2 Feature Feedback (1996) [WebDNA] Credit card processing (2012) Help! WebCat2 bug (1997) RE: Lookup Notfound (1998) [ShowIf] a either fields are blank (1998) Redirecting some image requests ... (2003) form data submission gets truncated (1997) Frames and WebCat (1997) New Website with Redakto CMS (2003) [listfiles] (1998) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Problems passing [SKU] with $Replace in 2.0 (1997) Under Score (1999) [format xs] freeze (1997) Price Change (1999) [if] (2003)