oddball sorting problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 55043
interpreted = N
texte = I have this: [search ....group1field=date1+date2&group1type=date&gegroup1datarq=[date]&date1type=date&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/
Associated Messages, from the most recent to the oldest:
I have this: [search ....group1field=date1+date2&group1type=date&gegroup1datarq=[date]&date1type=date&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/
Terry Wilson
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:
calculating tax rates, mail order solutions and version 2 (1997)
Plugin or CGI or both (1997)
WebDNA 5.1 is now available! (2003)
[WebDNA] [WSC] WebDNA Development Summit (2014)
Delete only one duplicate record? (2003)
[/application] error? (1997)
Uploading stuff along with variables (2006)
Associative lookup style? + bit more (1997)
WebDNA Solutions ... sorry! (1997)
Proposed FormVariables hierarchy (2000)
Help name our technology! (1997)
[WebDNA] Help me install WebDNA (2012)
same bill to and ship to? (1998)
Multiple Passwords (1997)
WebDNA problems with Itools 7.3 Upgrade (2004)
field validation problem (1999)
Flash Stores (2003)
Setting up WebCatalog with Retail Pro data (1996)
Re:quit command on NT (1997)
[WebDNA] Local Development On Windows 8.1 (2015)