Re: Sorting... stumped.
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 63779
interpreted = N
texte = Whoops, alphabetical won't work I should have laid off the sauce in kindergarten..)... so now I'm back to square one... any ideas? temp db?-DanOn Sun, 08 Jan 2006 10:31:09 -0800 "Dan Strong"
wrote:> Need to sort results using a field that contains only the following 3 values in each record T, Q >& N.> > Client wants sort order as follows:> If T is chosen, then sort TQN> If Q is chosen then sort QTN> If N is chosen then sort NTQ> > No prob if T or N is chosen. I just toggle the sdir=as or sdir=de in the search string as >appropriate and it works alphabetically. But how do I handle it if Q is chosen?> > Sample code:> ------------------> [!]-- [the-topic] is fed to this code from a different page. Values are either T, Q or N --[/!]> [text >show=f]searchMethod=eqShortCategoryDataRq=[url][p][/url]&neSkuData=[blank]&sortKeyType=num&productTypeSdir=[showif >[the_topic]=T]de[/showif][showif >[the_topic]=N]as[/showif]&productTypeSort=1&sortKeySort=2&catIDsumm=T&allReqd=T[/text]> > How to handle if [the_topic]=Q ????> -Dan> > -------------------------------------------------------------> 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:
Whoops, alphabetical won't work I should have laid off the sauce in kindergarten..)... so now I'm back to square one... any ideas? temp db?-DanOn Sun, 08 Jan 2006 10:31:09 -0800 "Dan Strong" wrote:> Need to sort results using a field that contains only the following 3 values in each record T, Q >& N.> > Client wants sort order as follows:> If T is chosen, then sort TQN> If Q is chosen then sort QTN> If N is chosen then sort NTQ> > No prob if T or N is chosen. I just toggle the sdir=as or sdir=de in the search string as >appropriate and it works alphabetically. But how do I handle it if Q is chosen?> > Sample code:> ------------------> [!]-- [the-topic] is fed to this code from a different page. Values are either T, Q or N --[/!]> [text >show=f]searchMethod=eqShortCategoryDataRq=[url][p][/url]&neSkuData=[blank]&sortKeyType=num&productTypeSdir=[showif >[the_topic]=T]de[/showif][showif >[the_topic]=N]as[/showif]&productTypeSort=1&sortKeySort=2&catIDsumm=T&allReqd=T[/text]> > How to handle if [the_topic]=Q ????> -Dan> > -------------------------------------------------------------> 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/
"Dan Strong"
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:
OFF-TOPIC...list serve software for newsletter? (1998)
RE: can we get string variables? (1998)
For those of you not on the WebCatalog Beta... (1997)
Personal Web Server (1998)
ups (1999)
[Webcat 2]Next (1997)
Webcatalog error, Plug-in for Webstar (1996)
[WebDNA] Encrypted password issue (2009)
WC2f3 (1997)
Grepping spaces (2004)
Show if time tags (1997)
[WebDNA] Authorize working connection... (2019)
More questions about serial number dishing (1997)
Faxing orders in place of email (1997)
Emailer Set Up (1997)
unsubscribe (2000)
The USArea® Network web site ... (1997)
Hiding HTML and breaking the page (1997)
[sendmail] v. [writefile] (2000)
PCS Frames (1997)