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:
[ShowNext] (1997)
WebCat2 - [format thousands] (1997)
Pithy questions on webcommerce & siteedit (1997)
showif comparison begins w/ and contains (1997)
problem serving foreign languages text (1997)
OT - webdnadev.net ...... links bad??? (2005)
Sorting search by date. (2000)
WebCat vs MS SiteServer? (1999)
PIXO support (1997)
Bug Report, maybe (1997)
remotely add + sign (1997)
Database Not Found Problem (2004)
Emailer help....! (1997)
Referrer from multiple entry points (1998)
Large Database Options? (1999)
NT License trade for Mac (2000)
PCS Frames (1997)
SiteGaurd file Cache vs webcatalog cache (1997)
Separate SSL Server (1997)
'does not contain' operator needed ... (1997)