Re: resorting found set

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60848
interpreted = N
texte = You CAN pass a variable with an equal sign in it if you URL the value: =20= "&sort=3D[url]aspricesort=3D1[/url]" As for the startat value, in your top two links you specify =20 "startat=3D1", while in the shownext loop you specify "startnum=3D...". =20= Your search is using "[startnum]", so this part probably works okay =20 despite the confused code. - Brian On Jan 25, 2005, at 10:13 PM, Nitai @ ComputerOil wrote: > Hi > > 1. You can NOT pass a variable like "&sort=3Daspricesort=3D1". You = will =20 > have to pass this like: &sort=3Daspricesort&sort2=3D1". You search = code =20 > then has to look like this: search db=3Dxxxx.db&[sort]=3D[sort2]. > > 2. You are aware that your search will always start at position "1" =20= > when you pass the startat=3D1 parameter, right? > > Nitai > > -- > Redakto - Content Management that simply works > Content Management & eBusiness Systems > > ComputerOil=AE AG > Dammstrasse 7 > 5400 Baden / Switzerland > Telefon +41 (0)844 44 55 66 > > info@computeroil.com > http://computeroil.com > >> -----Original Message----- >> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf =20= >> Of >> Steve Chun >> Sent: Mittwoch, 26. Januar 2005 06:59 >> To: WebDNA Talk >> Subject: resorting found set >> >> I'm wondering if I can get away from using tables by swapping out the >> "sort" value within the search context. It works for the first page = of >> results but when I click on the link for the next page of results, = the >> items are returned in a random order. I've gone through all the >> talk-list history and can't seem to find a solution to this. Any help >> is appreciated. >> >> >> Here is the test page: >> >> http://bestwinesupdate.com/index-test.htm >> >> and the stripped down code for the results page: >> >> >> >> Sort by >> Price >>
>> Sort >> by Variety >> >> >> >> [search >> = db=3Dwines.db&rnpricedatarq=3D[price]&[sort]&wsvarietydatarq=3D[variety]&m= ax=20 >> =3D2 >> 5&startat=3D[startnum]] >> [text show=3Df]dividerA=3D[math]ceil([numfound]/25)[/math][/text] >> >> [foundItems] >> [name] [variety] [price] >> [/foundItems] >> >> >> >> >> !Shownext loop here: >> >> [Loop start=3D1&end=3D[dividerA]] >> > href=3D"results.htm?startnum=3D[math]([index]*25)-24[/math]">[index] >> | >> [/Loop] >> >> >> Steve > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com =20= -- ------------------------------------------------------------- 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: resorting found set ( "Steve Chun" 2005)
  2. Re: resorting found set ( John Peacock 2005)
  3. Re: resorting found set ( Steve Chun 2005)
  4. Re: resorting found set ( "Nitai @ ComputerOil" 2005)
  5. Re: resorting found set ( Steve Chun 2005)
  6. Re: resorting found set ( "Nitai @ ComputerOil" 2005)
  7. Re: resorting found set ( Brian Fries 2005)
  8. Re: resorting found set ( "Nitai @ ComputerOil" 2005)
  9. resorting found set ( Steve Chun 2005)
You CAN pass a variable with an equal sign in it if you URL the value: =20= "&sort=3D[url]aspricesort=3D1[/url]" As for the startat value, in your top two links you specify =20 "startat=3D1", while in the shownext loop you specify "startnum=3D...". =20= Your search is using "[startnum]", so this part probably works okay =20 despite the confused code. - Brian On Jan 25, 2005, at 10:13 PM, Nitai @ ComputerOil wrote: > Hi > > 1. You can NOT pass a variable like "&sort=3Daspricesort=3D1". You = will =20 > have to pass this like: &sort=3Daspricesort&sort2=3D1". You search = code =20 > then has to look like this: search db=3Dxxxx.db&[sort]=3D[sort2]. > > 2. You are aware that your search will always start at position "1" =20= > when you pass the startat=3D1 parameter, right? > > Nitai > > -- > Redakto - Content Management that simply works > Content Management & eBusiness Systems > > ComputerOil=AE AG > Dammstrasse 7 > 5400 Baden / Switzerland > Telefon +41 (0)844 44 55 66 > > info@computeroil.com > http://computeroil.com > >> -----Original Message----- >> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf =20= >> Of >> Steve Chun >> Sent: Mittwoch, 26. Januar 2005 06:59 >> To: WebDNA Talk >> Subject: resorting found set >> >> I'm wondering if I can get away from using tables by swapping out the >> "sort" value within the search context. It works for the first page = of >> results but when I click on the link for the next page of results, = the >> items are returned in a random order. I've gone through all the >> talk-list history and can't seem to find a solution to this. Any help >> is appreciated. >> >> >> Here is the test page: >> >> http://bestwinesupdate.com/index-test.htm >> >> and the stripped down code for the results page: >> >> >> >> [cart]&sort=3Daspricesort=3D1&startat=3D1= ">Sort by >> Price >>
>> [cart]&sort=3Dasvarietysort=3D1&startat=3D= 1">Sort >> by Variety >> >> >> >> [search >> = db=3Dwines.db&rnpricedatarq=3D[price]&[sort]&wsvarietydatarq=3D[variety]&m= ax=20 >> =3D2 >> 5&startat=3D[startnum]] >> [text show=3Df]dividerA=3D[math]ceil([numfound]/25)[/math][/text] >> >> [founditems] >> [name] [variety] [price] >> [/foundItems] >> >> >> >> >> !Shownext loop here: >> >> [Loop start=3D1&end=3D[dividerA]] >> > href=3D"results.htm?startnum=3D[math]([index]*25)-24[/math]">[index] >> | >> [/Loop] >> >> >> Steve > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com =20= -- ------------------------------------------------------------- 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/ 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:

Search bug. Help (2002) WebCat2 Append problem (B14Macacgi) (1997) [WebDNA] LowRam (2012) show if date < expiry date (2002) RE: Going to anchors within a template page (1997) Signal Raised (1997) wrong input values? (1997) [OT] Java Scroller (2006) Size limit for tmpl editor ? (1997) TCP Connect (1999) PCS Frames (1997) [append] - illegal characters? (2000) wo search help (1999) Silly date question (2006) WebCat2 several catalogs? (1997) access denied problem (1997) FW: WebDNA-Talk searchable? (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Math Context (1998) StoreBuilder Shopping Cart (2000)