Re: Help: sorting in found set.

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39565
interpreted = N
texte = So... your search returns 1,2,3,4,5 and page 2 would show 6... You want to be able to show 5,4,3,2,1 with page 2 still showing 6...Correct?The only way that comes to mind for me is to write your results for 1-5 to a temporary database, then search on that with a reverse sort and display the results, then delete the temporary database.- brian At 2:05 PM -0800 10/23/2001, Marc M. wrote: >Mac os9,webstar,webcat 4.01 > >I am looking for a way to sort found items. I have a search result page that >uses an imbedded search: > >[search db=serials.db&[formvariables name=_&exact=F][getchars >start=2][name][/getchars]=[url][value][/url]&[/formvariables]startat=[starta >t]&[sortfield]sort=1&[sortfield]sdir=[sortdirection]&max=[show]] > >which is fairly simple. The only deviation is that the sort field and >sdir=as can be changed. > >my problem comes when I have 6 found items and I used max=5. my first page >shows 5 items 1,2,3,4,5 and I get a hyperlink to 6. > >above the column of results I have 2 hyperlinks > >name=_&exact=F][name]=[url][value][/url]&[/formvariables]startat=[startat]&s >ortfield=serial_number&sortdirection=de&max=[show]> > >which searches sorts decending. Shows 1,2,3,4,5 > >name=_&exact=F][name]=[url][value][/url]&[/formvariables]startat=[startat]&s >ortfield=serial_number&sortdirection=as&max=[show]> > >which searches sorts ascending. Shows 6,5,4,3,2 not exactly what i wanted. > >I would like to sdir into the result of the original found items which would >give me 5,4,3,2,1. > >Is there a way to position=start, position=end in this type of search so i >can re-sort the first 5 found. > >Any help would be appreciated.------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Help: sorting in found set. (Marc M. 2001)
  2. Re: Help: sorting in found set. (Brian Fries 2001)
  3. Re: Help: sorting in found set. (Brian Fries 2001)
  4. Help: sorting in found set. (Marc M. 2001)
So... your search returns 1,2,3,4,5 and page 2 would show 6... You want to be able to show 5,4,3,2,1 with page 2 still showing 6...Correct?The only way that comes to mind for me is to write your results for 1-5 to a temporary database, then search on that with a reverse sort and display the results, then delete the temporary database.- brian At 2:05 PM -0800 10/23/2001, Marc M. wrote: >Mac os9,webstar,webcat 4.01 > >I am looking for a way to sort found items. I have a search result page that >uses an imbedded search: > >[search db=serials.db&[formvariables name=_&exact=F][getchars >start=2][name][/getchars]=[url][value][/url]&[/formvariables]startat=[starta >t]&[sortfield]sort=1&[sortfield]sdir=[sortdirection]&max=[show]] > >which is fairly simple. The only deviation is that the sort field and >sdir=as can be changed. > >my problem comes when I have 6 found items and I used max=5. my first page >shows 5 items 1,2,3,4,5 and I get a hyperlink to 6. > >above the column of results I have 2 hyperlinks > >name=_&exact=F][name]=[url][value][/url]&[/formvariables]startat=[startat]&s >ortfield=serial_number&sortdirection=de&max=[show]> > >which searches sorts decending. Shows 1,2,3,4,5 > >name=_&exact=F][name]=[url][value][/url]&[/formvariables]startat=[startat]&s >ortfield=serial_number&sortdirection=as&max=[show]> > >which searches sorts ascending. Shows 6,5,4,3,2 not exactly what i wanted. > >I would like to sdir into the result of the original found items which would >give me 5,4,3,2,1. > >Is there a way to position=start, position=end in this type of search so i >can re-sort the first 5 found. > >Any help would be appreciated.------------------------------------------------------------- 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://search.smithmicro.com/ Brian Fries

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:

XML Woes [Hijacked Thread] (2004) SetCookie / GetCookie Problem.... (2004) Next X hits (1996) Colors in cart (2002) Aaron kant add (or whatever it was) (2000) WebMerchant email template format? (1997) WebCat2.0b15-to many nested [xx] tags (1997) nested context (1998) Hyperboard users wanting a quoted message (1998) WebCat2b15MacPlugin - showing [math] (1997) GoLive CyberStudio 1.0.1 (1997) What am I missing (1997) japanese characters (1997) [WriteFile] problems (1997) Setting up WebCatalog with Retail Pro data (1996) [ConvertChars] problem (1997) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) Variable prices and Formulas.db (1997) [Announce]: Web server security and password protection (1997) Help name our technology! (1997)