Re: resorting found set
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 60853
interpreted = N
texte = I had used a different variable name for [sort]. Just making it easier =20= to follow here on the list. I'm passing along several variables - which I've cut out to make it =20 easier to troubleshoot here since the search is working fine. It's just =20= the sorting that is not working beyond the first page of 25 results. Steve On Wednesday, January 26, 2005, at 02:01 AM, Nitai @ ComputerOil wrote: > This thread is confusing. I thought Brian was the poster. Sorry to my =20= > last answer Brian. > > Anyhow, I have found that if you name your variable [sort] then WebDNA = =20 > gets confused. Rename your variable and see if that works. Also, =20 > looking at your search again, you are also looking for [variety], =20 > since this is needed on your search, as you use "rq", are you also =20 > passing that value, too? > > 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 07:54 >> To: WebDNA Talk >> Subject: Re: resorting found set >> >> I added the [url] ... [/url] to the code and taken out the = "startat=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 @ ComputerOil =20 >> wrote: >> >>> Of course you can pass variables like this if you URL your code as =20= >>> 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 the >>> 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 >>>> 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 =20 >>>> 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 =20 >>>>>> 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 >>>>>> the >>>>>> "sort" value within the search context. It works for the first =20= >>>>>> 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: >>>>>> >>>>>> >>>>>> >>>>>>
>>>>> href=3D"results.htm?cart=3D[cart]&sort=3Daspricesort=3D1&startat=3D= 1">Sort >>>>>> by >>>>>> Price >>>>>>
>>>>>>
>>>>> = href=3D"results.htm?cart=3D[cart]&sort=3Dasvarietysort=3D1&startat=3D1">So= rt >>>>>> by Variety >>>>>> >>>>>> >>>>>> >>>>>> [search >>>>>> = db=3Dwines.db&rnpricedatarq=3D[price]&[sort]&wsvarietydatarq=3D[variety]=20= >>>>>> &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[/=20 >>>>>> 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 =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 had used a different variable name for [sort]. Just making it easier =20= to follow here on the list. I'm passing along several variables - which I've cut out to make it =20 easier to troubleshoot here since the search is working fine. It's just =20= the sorting that is not working beyond the first page of 25 results. Steve On Wednesday, January 26, 2005, at 02:01 AM, Nitai @ ComputerOil wrote: > This thread is confusing. I thought Brian was the poster. Sorry to my =20= > last answer Brian. > > Anyhow, I have found that if you name your variable [sort] then WebDNA = =20 > gets confused. Rename your variable and see if that works. Also, =20 > looking at your search again, you are also looking for [variety], =20 > since this is needed on your search, as you use "rq", are you also =20 > passing that value, too? > > 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 07:54 >> To: WebDNA Talk >> Subject: Re: resorting found set >> >> I added the [url] ... [/url] to the code and taken out the = "startat=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 @ ComputerOil =20 >> wrote: >> >>> Of course you can pass variables like this if you URL your code as =20= >>> 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 the >>> 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 >>>> 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 =20 >>>> 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 =20 >>>>>> 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 >>>>>> the >>>>>> "sort" value within the search context. It works for the first =20= >>>>>> 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: >>>>>> >>>>>> >>>>>> >>>>>> >>>>> href=3D"results.htm?cart=3D[cart]&sort=3Daspricesort=3D1&startat=3D= 1">Sort >>>>>> by >>>>>> Price >>>>>>
>>>>>> >>>>> = href=3D"results.htm?cart=3D[cart]&sort=3Dasvarietysort=3D1&startat=3D1">So= rt >>>>>> by Variety >>>>>> >>>>>> >>>>>> >>>>>> [search >>>>>> = db=3Dwines.db&rnpricedatarq=3D[price]&[sort]&wsvarietydatarq=3D[variety]=20= >>>>>> &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[/=20 >>>>>> 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 =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:
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
ANNC: Cool New WebCat Site!!! (Lotsa Flash) (2000)
[WebDNA] Credit card processing (2012)
(1997)
Initiating NewCart (1997)
WebCat2b12--[searchstring] bug (1997)
Protect (1997)
Client-side Image Maps and WebCat? (1998)
More than one db with the same namn (was: WC2f3) (1997)
Template Not Found (1998)
lookups or math? (1998)
[WebDNA] A new popuated field to a DB with 700.000 records (2009)
WebCat2final1 crashes (1997)
Can't Search field (1998)
UPS Shipping Calculations (2001)
Convertchars problem? (2000)
2.0Beta Command Ref (can't find this instruction) (1997)
Emailer setup (1997)
notification solutions (1997)
Multiple SSL Keys (1998)