Re: Sorting... stumped.

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 63781
interpreted = N
texte = Ok. After much thought, all I can come up with here is doing 3 separate searches in whatever order is needed. I was hoping to find a more elegant way, but I'm not finding it and deadline looms. Any thoughts on this? Anybody? -Dan On Sun, 08 Jan 2006 10:37:31 -0800 "Dan Strong" wrote: > Grrr. I wish I could take back these posts sometimes... ok, alphabetical works for client >requirement if T is chosen (TQN) > > [showif [the_topic]=T] > [text >show=f]searchMethod=eqShortCategoryDataRq=[url][p][/url]&neSkuData=[blank]&sortKeyType=num&productTypeSdir=de&productTypeSort=1&sortKeySort=2&catIDsumm=T&allReqd=T[/text] > [/showif] > > Stumped on Q & N ??? > -Dan > > > On Sun, 08 Jan 2006 10:33:52 -0800 > "Dan Strong" wrote: >> 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? >> -Dan >> >> On 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/ > > > ------------------------------------------------------------- > 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: Sorting... stumped. ( "Dan Strong" 2006)
  2. Re: Sorting... stumped. ( Frank Nordberg 2006)
  3. Re: Sorting... stumped. ( "Dan Strong" 2006)
  4. Re: Sorting... stumped. ( Alex McCombie 2006)
  5. Re: Sorting... stumped. ( "Dan Strong" 2006)
  6. Re: Sorting... stumped. ( Alex McCombie 2006)
  7. Re: Sorting... stumped. ( "Dan Strong" 2006)
  8. Re: Sorting... stumped. ( "Dan Strong" 2006)
  9. Re: Sorting... stumped. ( "Dan Strong" 2006)
  10. Sorting... stumped. ( "Dan Strong" 2006)
Ok. After much thought, all I can come up with here is doing 3 separate searches in whatever order is needed. I was hoping to find a more elegant way, but I'm not finding it and deadline looms. Any thoughts on this? Anybody? -Dan On Sun, 08 Jan 2006 10:37:31 -0800 "Dan Strong" wrote: > Grrr. I wish I could take back these posts sometimes... ok, alphabetical works for client >requirement if T is chosen (TQN) > > [showif [the_topic]=T] > [text >show=f]searchMethod=eqShortCategoryDataRq=[url][p][/url]&neSkuData=[blank]&sortKeyType=num&productTypeSdir=de&productTypeSort=1&sortKeySort=2&catIDsumm=T&allReqd=T[/text] > [/showif] > > Stumped on Q & N ??? > -Dan > > > On Sun, 08 Jan 2006 10:33:52 -0800 > "Dan Strong" wrote: >> 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? >> -Dan >> >> On 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/ > > > ------------------------------------------------------------- > 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:

Add to a field (1998) MacWEEK article help needed (1996) Configuring E-mail (1997) Big Databases (1997) Multiple Sendmail Tags on One Page (2008) foreign languages, email, webcat (1998) international time (1997) This Code Kills My WebCatalog Dead (2003) Re:Virtual hosting and webcatNT (1997) Extended [ConvertChars] (1997) Template Cache problem (2000) Smart caching problems with 2.1b3? (1997) 'does not contain' operator needed ... (1997) Talk Archives down? (2002) Location of Browser Info.txt file (1997) NT vs Mac (1997) searching multiple databases (1997) Stumpted Again (1997) many-to-one problem (1998) POSTing to a secure server ... (2000)