Re: [WebDNA] sort parameters in search
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 111844
interpreted = N
texte = As for an example, right now I'm displaying images which are in various libr=aries, added to the site at regular intervals. When someone searches for a c=ategory, I want the results to be by date added, then file name (so they'll b=e in order). Unless the category is big feet. Then I want it to be by shoe s=ize, then date, then file name.A similar scenario plays out when you have sortable headings in a table, whe=n the same search is expected to sort differently under a number of conditio=ns.I realize after my previous email that programmatically it's not a numerical= thing but merely an instruction and sort1 etc are merely instructions, so m=aybe it's not that simple to change.Sent from my iPad> On Jan 12, 2015, at 7:12 AM, Donovan Brooke
wrote:>=20> Hi Terry,>=20> Are you saying later sort params get ignored if prior sort params don=E2=80==99t apply?>=20> Can you post a test template and your desired results?>=20> Donovan>=20>=20>=20>=20>=20>=20>> On Jan 11, 2015, at 11:06 PM, Terry Wilson wrote:>>=20>> I'd really to see the sort parameters in [search] sort regardless of the s=pecified number. How do I explain this.>>=20>> &fieldAsort=3D1&fieldBsort=3D2&fieldCsort=3D3&fieldDsort=3D4>>=20>> But I only need fieldA to lead the sort for one condition. So unless that= comes up, I just hide fieldAsort=3D1 like so:>>=20>> [showif [specialcase]=3Dt]&fieldAsort=3D1[/showif]&fieldBsort=3D2&fieldCs=ort=3D3&fieldDsort=3D4>>=20>> This comes up from time to time, and actually right now it's coming up fo=r me again and as usual, I have to showif/hideif the entire sort string for e=ach condition instead of just slipping in the one that I need for certain ca=ses.>>=20>> [showif [specialcase]=3Dt]&fieldAsort=3D1&fieldBsort=3D2&fieldCsort=3D3&f=ieldDsort=3D4[/showif]>> [hideif [specialcase]=3Dt]&fieldBsort=3D1&fieldCsort=3D2&fieldDsort=3D3[/=hideif]>>=20>> kind of a pain in the ass when you're still deciding what to best sort on= - now you have 2 places to futz with as you refine.>>=20>> Bonus points to also let those numbers be decimal. Let's say sometimes yo=u need an additional sort in the middle. Throw a showif on fieldZsort=3D2.5 a=s needed:>>=20>> &fieldAsort=3D1&fieldBsort=3D2&fieldZsort=3D2.5&fieldCsort=3D3&fieldDsort==3D4--------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us>> Bug Reporting: support@webdna.us>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
As for an example, right now I'm displaying images which are in various libr=aries, added to the site at regular intervals. When someone searches for a c=ategory, I want the results to be by date added, then file name (so they'll b=e in order). Unless the category is big feet. Then I want it to be by shoe s=ize, then date, then file name.A similar scenario plays out when you have sortable headings in a table, whe=n the same search is expected to sort differently under a number of conditio=ns.I realize after my previous email that programmatically it's not a numerical= thing but merely an instruction and sort1 etc are merely instructions, so m=aybe it's not that simple to change.Sent from my iPad> On Jan 12, 2015, at 7:12 AM, Donovan Brooke wrote:>=20> Hi Terry,>=20> Are you saying later sort params get ignored if prior sort params don=E2=80==99t apply?>=20> Can you post a test template and your desired results?>=20> Donovan>=20>=20>=20>=20>=20>=20>> On Jan 11, 2015, at 11:06 PM, Terry Wilson wrote:>>=20>> I'd really to see the sort parameters in [search] sort regardless of the s=pecified number. How do I explain this.>>=20>> &fieldAsort=3D1&fieldBsort=3D2&fieldCsort=3D3&fieldDsort=3D4>>=20>> But I only need fieldA to lead the sort for one condition. So unless that= comes up, I just hide fieldAsort=3D1 like so:>>=20>> [showif [specialcase]=3Dt]&fieldAsort=3D1[/showif]&fieldBsort=3D2&fieldCs=ort=3D3&fieldDsort=3D4>>=20>> This comes up from time to time, and actually right now it's coming up fo=r me again and as usual, I have to showif/hideif the entire sort string for e=ach condition instead of just slipping in the one that I need for certain ca=ses.>>=20>> [showif [specialcase]=3Dt]&fieldAsort=3D1&fieldBsort=3D2&fieldCsort=3D3&f=ieldDsort=3D4[/showif]>> [hideif [specialcase]=3Dt]&fieldBsort=3D1&fieldCsort=3D2&fieldDsort=3D3[/=hideif]>>=20>> kind of a pain in the ass when you're still deciding what to best sort on= - now you have 2 places to futz with as you refine.>>=20>> Bonus points to also let those numbers be decimal. Let's say sometimes yo=u need an additional sort in the middle. Throw a showif on fieldZsort=3D2.5 a=s needed:>>=20>> &fieldAsort=3D1&fieldBsort=3D2&fieldZsort=3D2.5&fieldCsort=3D3&fieldDsort==3D4--------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us>> Bug Reporting: support@webdna.us>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
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:
[TEXT SECURE=T] (2000)
OT: JavaScript question (2001)
ASP and WebDNA (1998)
[WebDNA] find missing file in [listfiles] (2019)
Emailer (1997)
RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error (2019)
Convert characters (2002)
How true is this? (1999)
Re:WebCatalog f2 Installation (1997)
OK, here goes... (1997)
RE: protect tag on NT (1997)
URGENT - CPU usage OSXS (2001)
Time Display from Database (1997)
webCat craps httpd (2005)
Problems appending to database (1997)
Online reference (1997)
[BoldWords] WebCat.acgib15Mac (1997)
select multiple (1997)
[authenticate] (1999)
Mystery File (2005)