Re: resorting found set
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 60850
interpreted = N
texte = I added the [url] ... [/url] to the code and taken out the "startat=3D1" = =20 but no effect. I'm a relative newbie and wouldn't have known to have =20 that code in the link. sc On Wednesday, January 26, 2005, at 01:50 AM, Nitai @ ComputerOil wrote: > Of course you can pass variables like this if you URL your code as you = =20 > write, BUT in your example this was not the case. > > Post your correct code the next time, if you want us to help in the =20= > right why. As you state yourself, your posted code is confusing. > > How am I to know at which state you are in coding? > > 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 >> 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 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 search = code >>> 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" >>> 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 >>>> 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 =20= >>>> the >>>> "sort" value within the search context. It works for the first page = =20 >>>> of >>>> results but when I click on the link for the next page of results, =20= >>>> 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 =20= >>>> help >>>> is appreciated. >>>> >>>> >>>> Here is the test page: >>>> >>>> http://bestwinesupdate.com/index-test.htm >>>> >>>> and the stripped down code for the results page: >>>> >>>> >>>> >>>>
Sort =20 >>>> by >>>> Price >>>>
>>>>
>>> href=3D"results.htm?cart=3D[cart]&sort=3Dasvarietysort=3D1&startat=3D= 1">Sort >>>> by Variety >>>> >>>> >>>> >>>> [search >>>> = db=3Dwines.db&rnpricedatarq=3D[price]&[sort]&wsvarietydatarq=3D[variety]&m= =20 >>>> 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 -- =20 >> 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 =20 > > 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:
I added the [url] ... [/url] to the code and taken out the "startat=3D1" = =20 but no effect. I'm a relative newbie and wouldn't have known to have =20 that code in the link. sc On Wednesday, January 26, 2005, at 01:50 AM, Nitai @ ComputerOil wrote: > Of course you can pass variables like this if you URL your code as you = =20 > write, BUT in your example this was not the case. > > Post your correct code the next time, if you want us to help in the =20= > right why. As you state yourself, your posted code is confusing. > > How am I to know at which state you are in coding? > > 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 >> 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 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 search = code >>> 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" >>> 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 >>>> 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 =20= >>>> the >>>> "sort" value within the search context. It works for the first page = =20 >>>> of >>>> results but when I click on the link for the next page of results, =20= >>>> 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 =20= >>>> 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=3D= 1">Sort =20 >>>> by >>>> Price >>>>
>>>> >>> href=3D"results.htm?cart=3D[cart]&sort=3Dasvarietysort=3D1&startat=3D= 1">Sort >>>> by Variety >>>> >>>> >>>> >>>> [search >>>> = db=3Dwines.db&rnpricedatarq=3D[price]&[sort]&wsvarietydatarq=3D[variety]&m= =20 >>>> 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 -- =20 >> 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 =20 > > 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/
Steve Chun
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:
[Sum] function? (1997)
math on date? (1997)
all records returned. (1997)
links to .db's ? (1999)
Just Testing (1997)
'page impression' techniques for banner ads (1999)
question: Eudora 3.1.1 (1997)
[WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011)
Plugin or CGI or both (1997)
A question on sub-categories (1997)
Who is doing sign-ups-got it (1998)
Progress !! WAS: Trouble with formula.db (1997)
banner ad redirection page (1999)
[WriteFile] problems (1997)
Quit revisited (1997)
2.0 Info (1997)
HELP WITH DATES (1997)
Mozilla/4. and Browser Info.txt (1997)
default image if image in code not available (2003)
newbie question about zip code search (2003)