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:

WebStar WebCat Crashing a lot (2004) ups quickcost [repost] (1999) Changes to the List (1997) Bug (feature) in v6 listfiles shows hidden files ... (2004) Bug or syntax error on my part? (1997) Logging purchases (1997) WebCatalog can't find database (1997) [OT] Discussion forum, last visit, Cookie, ... (2003) Email template names (1997) Finding max value for a field (1997) Don't tick me off :) [elaspedtime] (1997) How to add product size choices to form? (1997) [addlineitems] display (1997) Translation Considerations with DNA (2005) Major Security Hole (1998) [ShowNext] (1997) Showif, Hideif reverse logic ? (1997) PHP Live (2005) random prob (2003) UPS Quick Cost Calculator (1997)