Re: resorting found set

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60851
interpreted = N
texte = This thread is confusing. I thought Brian was the poster. Sorry t= o my last answer Brian. Anyhow, I have found that if you name your variable [sort] then W= ebDNA gets confused. Rename your variable and see if that works.=20= Also, looking at your search again, you are also looking for [var= iety], since this is needed on your search, as you use "rq", are=20= you also passing that value, too? Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=C2=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 B= ehalf Of > Steve Chun > Sent: Mittwoch, 26. Januar 2005 07:54 > To: WebDNA Talk > Subject: Re: resorting found set > > I added the [url] ... [/url] to the code and taken out the "sta= rtat=3D1" > but no effect. I'm a relative newbie and wouldn't have known to= have > that code in the link. > > > sc > > > > > > On Wednesday, January 26, 2005, at 01:50 AM, Nitai @ ComputerO= il wrote: > > > Of course you can pass variables like this if you URL your co= de as you > > write, BUT in your example this was not the case. > > > > Post your correct code the next time, if you want us to help=20= in the > > right why. As you state yourself, your posted code is confusi= ng. > > > > How am I to know at which state you are in coding? > > > > Nitai > > > > -- > > Redakto - Content Management that simply works > > Content Management & eBusiness Systems > > > > ComputerOil=C2=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] O= n Behalf > >> Of > >> Brian Fries > >> Sent: Mittwoch, 26. Januar 2005 07:30 > >> To: WebDNA Talk > >> Subject: Re: resorting found set > >> > >> You CAN pass a variable with an equal sign in it if you URL=20= the value: > >> "&sort=3D[url]aspricesort=3D1[/url]" > >> > >> As for the startat value, in your top two links you specify > >> "startat=3D1", while in the shownext loop you specify "start= num=3D...". > >> Your search is using "[startnum]", so this part probably wor= ks okay > >> 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=3D= 1". You will > >>> have to pass this like: &sort=3Daspricesort&sort2=3D1". You= search code > >>> then has to look like this: search db=3Dxxxx.db&[sort]=3D[s= ort2]. > >>> > >>> 2. You are aware that your search will always start at posi= tion "1" > >>> when you pass the startat=3D1 parameter, right? > >>> > >>> Nitai > >>> > >>> -- > >>> Redakto - Content Management that simply works > >>> Content Management & eBusiness Systems > >>> > >>> ComputerOil=C2=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 > >>>> 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 swapp= ing out > >>>> the > >>>> "sort" value within the search context. It works for the f= irst page > >>>> of > >>>> results but when I click on the link for the next page of=20= results, > >>>> the > >>>> items are returned in a random order. I've gone through al= l the > >>>> talk-list history and can't seem to find a solution to thi= s. 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 > >>>>
> >>>> >>>> href=3D"results.htm?cart=3D[cart]&sort=3Dasvarietysort=3D1= &startat=3D1">Sort > >>>> by Variety > >>>> > >>>> > >>>> > >>>> [search > >>>> db=3Dwines.db&rnpricedatarq=3D[price]&[sort]&wsvarietydata= rq=3D[variety]&m > >>>> ax > >>>> =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]par> >> > >>>> > >>>> Steve > >>> > >> -- Brian Fries, BrainScan Software -- > >> http://www.brainscansoftware.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 >> digest@talk.smithmicro.com> > >> 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 digest@talk.smithmicro.com> > 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: 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)
This thread is confusing. I thought Brian was the poster. Sorry t= o my last answer Brian. Anyhow, I have found that if you name your variable [sort] then W= ebDNA gets confused. Rename your variable and see if that works.=20= Also, looking at your search again, you are also looking for [var= iety], since this is needed on your search, as you use "rq", are=20= you also passing that value, too? Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=C2=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 B= ehalf Of > Steve Chun > Sent: Mittwoch, 26. Januar 2005 07:54 > To: WebDNA Talk > Subject: Re: resorting found set > > I added the [url] ... [/url] to the code and taken out the "sta= rtat=3D1" > but no effect. I'm a relative newbie and wouldn't have known to= have > that code in the link. > > > sc > > > > > > On Wednesday, January 26, 2005, at 01:50 AM, Nitai @ ComputerO= il wrote: > > > Of course you can pass variables like this if you URL your co= de as you > > write, BUT in your example this was not the case. > > > > Post your correct code the next time, if you want us to help=20= in the > > right why. As you state yourself, your posted code is confusi= ng. > > > > How am I to know at which state you are in coding? > > > > Nitai > > > > -- > > Redakto - Content Management that simply works > > Content Management & eBusiness Systems > > > > ComputerOil=C2=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] O= n Behalf > >> Of > >> Brian Fries > >> Sent: Mittwoch, 26. Januar 2005 07:30 > >> To: WebDNA Talk > >> Subject: Re: resorting found set > >> > >> You CAN pass a variable with an equal sign in it if you URL=20= the value: > >> "&sort=3D[url]aspricesort=3D1[/url]" > >> > >> As for the startat value, in your top two links you specify > >> "startat=3D1", while in the shownext loop you specify "start= num=3D...". > >> Your search is using "[startnum]", so this part probably wor= ks okay > >> 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=3D= 1". You will > >>> have to pass this like: &sort=3Daspricesort&sort2=3D1". You= search code > >>> then has to look like this: search db=3Dxxxx.db&[sort]=3D[s= ort2]. > >>> > >>> 2. You are aware that your search will always start at posi= tion "1" > >>> when you pass the startat=3D1 parameter, right? > >>> > >>> Nitai > >>> > >>> -- > >>> Redakto - Content Management that simply works > >>> Content Management & eBusiness Systems > >>> > >>> ComputerOil=C2=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 > >>>> 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 swapp= ing out > >>>> the > >>>> "sort" value within the search context. It works for the f= irst page > >>>> of > >>>> results but when I click on the link for the next page of=20= results, > >>>> the > >>>> items are returned in a random order. I've gone through al= l the > >>>> talk-list history and can't seem to find a solution to thi= s. 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=3D= 1&startat=3D1">Sort > >>>> by > >>>> Price > >>>>
> >>>> >>>> href=3D"results.htm?cart=3D[cart]&sort=3Dasvarietysort=3D1= &startat=3D1">Sort > >>>> by Variety > >>>> > >>>> > >>>> > >>>> [search > >>>> db=3Dwines.db&rnpricedatarq=3D[price]&[sort]&wsvarietydata= rq=3D[variety]&m > >>>> ax > >>>> =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]par> >> > >>>> > >>>> Steve > >>> > >> -- Brian Fries, BrainScan Software -- > >> http://www.brainscansoftware.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 >> digest@talk.smithmicro.com> > >> 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 digest@talk.smithmicro.com> > 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/ "Nitai @ ComputerOil"

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:

Dummy Credit Card Number for debug? (1997) about this server and links to who (1997) Emailer prefs in two places ... (1997) Table code broken? (2004) Trouble with formula.db (1997) Hyperlink in email (2002) Urgent Help needed (1998) re: keep W* in front applescript? (try Cron) (1998) (p2) WebDNA 5 - Privacy Issue (Built in sniffer) (2003) Weird problems with [SHOWIF]s (1997) multi-paragraph fields (1997) Two stores, one server (1998) searching multiple databases in single search (1997) [WebDNA] Fwd: RETS... HELP! (2009) French characters in variables (2001) [click][/click] (1999) Ads.db (1997) [REFERRER] AND Truncation (1998) Add to Cart & List of Products (1997) Cart dilemma (2003)