Re: resorting found set
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 60849
interpreted = N
texte = Of course you can pass variables like this if you URL your code a=s you write, BUT in your example this was not the case.Post your correct code the next time, if you want us to help in t=he right why. As you state yourself, your posted code is confusin=g.How am I to know at which state you are in coding?Nitai--Redakto - Content Management that simply worksContent Management & eBusiness Systems ComputerOil=C2=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66 info@computeroil.comhttp://computeroil.com > -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B=ehalf 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 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 "startnum==3D...".> Your search is using "[startnum]", so this part probably works=20=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=3D1"=.. You will> > have to pass this like: &sort=3Daspricesort&sort2=3D1". You s=earch code> > then has to look like this: search db=3Dxxxx.db&[sort]=3D[sor=t2].> >> > 2. You are aware that your search will always start at positi=on "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] O=n 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 swappin=g out the> >> "sort" value within the search context. It works for the fir=st page of> >> results but when I click on the link for the next page of re=sults, the> >> items are returned in a random order. I've gone through all=20=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]&max> >> =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.brainscansoft=ware.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:
Of course you can pass variables like this if you URL your code a=s you write, BUT in your example this was not the case.Post your correct code the next time, if you want us to help in t=he right why. As you state yourself, your posted code is confusin=g.How am I to know at which state you are in coding?Nitai--Redakto - Content Management that simply worksContent Management & eBusiness Systems ComputerOil=C2=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66 info@computeroil.comhttp://computeroil.com > -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B=ehalf 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 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 "startnum==3D...".> Your search is using "[startnum]", so this part probably works=20=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=3D1"=.. You will> > have to pass this like: &sort=3Daspricesort&sort2=3D1". You s=earch code> > then has to look like this: search db=3Dxxxx.db&[sort]=3D[sor=t2].> >> > 2. You are aware that your search will always start at positi=on "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] O=n 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 swappin=g out the> >> "sort" value within the search context. It works for the fir=st page of> >> results but when I click on the link for the next page of re=sults, the> >> items are returned in a random order. I've gone through all=20=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=3D=1&startat=3D1">Sort> >> by Variety> >>> >>> >>> >> [search> >> db=3Dwines.db&rnpricedatarq=3D[price]&[sort]&wsvarietydatarq==3D[variety]&max> >> =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.brainscansoft=ware.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:
Forcing a NEWCART (1997)
Multiple Pulldowns (1997)
posts (1998)
need e-commerce recommendation (2004)
TRAINING videos - Prove IT. (1998)
RE: CloseDatabase (1997)
RE: Still Learning (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
[WebDNA] a major shift in strategy? (2008)
Database wiped clean (2005)
Price + Texte (1999)
MacAuthorize hub, no modal password dialog? (1997)
Nesting format tags (1997)
Linebreak as a delimiter in listwords? (2003)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
European Convention (2004)
Orderfile Question (2003)
Getting URL's entered manually (1997)
Conveting Characters to Graphics (1997)
Error Log.db --however (1997)