Re: [WebDNA] sort parameters in search
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 111843
interpreted = N
texte = Terry, I don=92t personally have much time these days to write out my = own test code for other peoples issues. However, I am trying to help. Maybe someone else can test this. Sincerely, Donovan On Jan 12, 2015, at 9:55 AM, Terry Wilson
wrote: > My guess is that sort1 is looked for, and if not found, no further = sorting is investigated. Likewise when there's no sort2, etc. You can = easily try this out on one of your own searches. >=20 > Sent from my iPad >=20 >> 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=92t 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 specified 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&fieldCsort=3D3&f= ieldDsort=3D4 >>>=20 >>> This comes up from time to time, and actually right now it's coming = up for me again and as usual, I have to showif/hideif the entire sort = string for each condition instead of just slipping in the one that I = need for certain cases. >>>=20 >>> [showif = [specialcase]=3Dt]&fieldAsort=3D1&fieldBsort=3D2&fieldCsort=3D3&fieldDsort= =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 you need an additional sort in the middle. Throw a showif on = fieldZsort=3D2.5 as needed: >>>=20 >>> = &fieldAsort=3D1&fieldBsort=3D2&fieldZsort=3D2.5&fieldCsort=3D3&fieldDsort=3D= 4--------------------------------------------------------- >>> 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 > --------------------------------------------------------- > 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:
Terry, I don=92t personally have much time these days to write out my = own test code for other peoples issues. However, I am trying to help. Maybe someone else can test this. Sincerely, Donovan On Jan 12, 2015, at 9:55 AM, Terry Wilson wrote: > My guess is that sort1 is looked for, and if not found, no further = sorting is investigated. Likewise when there's no sort2, etc. You can = easily try this out on one of your own searches. >=20 > Sent from my iPad >=20 >> 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=92t 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 specified 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&fieldCsort=3D3&f= ieldDsort=3D4 >>>=20 >>> This comes up from time to time, and actually right now it's coming = up for me again and as usual, I have to showif/hideif the entire sort = string for each condition instead of just slipping in the one that I = need for certain cases. >>>=20 >>> [showif = [specialcase]=3Dt]&fieldAsort=3D1&fieldBsort=3D2&fieldCsort=3D3&fieldDsort= =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 you need an additional sort in the middle. Throw a showif on = fieldZsort=3D2.5 as needed: >>>=20 >>> = &fieldAsort=3D1&fieldBsort=3D2&fieldZsort=3D2.5&fieldCsort=3D3&fieldDsort=3D= 4--------------------------------------------------------- >>> 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 > --------------------------------------------------------- > 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
Donovan Brooke
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:
BR (1997)
Off topic: to Jeroen (bouncing email) (2000)
question: back button prevention (1997)
Multi-processor Mac info ... (1997)
Questions To Answer (1997)
New public beta available (1997)
[WebDNA] [append] does not add the newline char at the end of the new record?! (which can causes subsequent [search] to fail.) (2009)
[SQL] - COUNT, SUM retrieval (2000)
Document Contains No Data! (1997)
SPAM is SPAM is SPAM.... Smith Micro - no competition (2000)
Who's going to MacWorld? (1999)
WC2b15 File Corruption (1997)
Dummy Credit Card Number for debug? (1997)
plus sign giving me problems in convertchars (2005)
Apoligy (1997)
price carry over (1997)
Cart questions (1997)
[TaxableTotal] - not working with AOL and IE (1997)
Malformed Pages (1999)
Sorting (1998)