Re: [WebDNA] Exclude found items in a 2nd search
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 112738
interpreted = N
texte = 321Because your sort is random. No two searches will be the same. It=20seemed to work the first time because it just didn't happen to find=20any of the previous ones. Please see my previous post and the followup=20by Lawrence.TerryOn Tue, 26 Apr 2016 10:31:41 -0500 Richard Kwasniewski
wrote: Not sure what happened, it seemed like adding the "startat=3D7" didwork initially, but no more.... I may have missed matching up the items. =20 here is my search code.: =20 =20 [search db=3D^/rs/products.db&woSECTIONSdatarq=3D12&SECTIONSword=3Dww&namewbrk=3D=+&eqVisibledatarq=3DT&eqFeatureddatarq=3DYes&TITLEsort=3D1&TITLEsdir=3Dra=&max=3D6] [founditems] 6 random items shown..... [/founditems] [/search] =20 =20 Right beneath this I would have my 2nd search: =20 [search db=3D^/rs/products.db&woSECTIONSdatarq=3D12&SECTIONSword=3Dww&namewbrk=3D=+&eqVisibledatarq=3DT&eqFeatureddatarq=3DYes&TITLEsort=3D1&TITLEsdir=3Dra=] [founditems] Show all other items omitting the 6 found above.... [/founditems] [/search] =20 =20 All this takes place on the exact same page, so cookies don't seem=20tobe an option.... =20 Trying the text variable route.... if I add this within the 1stsearch [text show=3DT]found=3D[SKU][/text] shows me the SKUs of the 6 chosen randomly in that 1st search, buthow would I place all 6 of those SKUs within that 2nd search? =20 &neSKUdatarq=3D[found] is what I was thinking, but that can't work on=206SKUs =20 =20 =20 =20 On Tue, Apr 26, 2016 at 8:09 AM, Lawrence Banahan wrote: =20> Hi, you could also use a hidden input to keep the previous IDs and=20>exclude> them from next search> Lawrence>> 2016-04-26 14:57 GMT+02:00 Terry Wilson :>>> But you said you were searching for random results. I don't see how=20>>this>> would work.>>>> You could collect the record IDs from the first search in a cookie,=20>>and>> exclude those from the second search, or if on the same page, collect=20>>them>> in a text variable.>>>> Terry>>>> Sent from my iPad>>>> On Apr 26, 2016, at 5:17 AM, Richard Kwasniewski=20>>>> wrote:>>>> Well all righty...>>>> That "startat=3D7" seems to work just fine with that 2nd search/result=s=20>>etc.>>>> Thanks>>>>>> On Tue, Apr 26, 2016 at 6:53 AM, Tom Duke =20>>wrote:>>>>> Richard,>>>>>> Hi - if you have the same search and sorting criteria, then add:>>>>>> &startat=3D7>>>>>> to your second search.>>>>>> - Tom>>>>>>>>>>>> --------------------------------------------------------- This=20>>>message>>> is sent to you because you are subscribed to the mailing list . To>>> unsubscribe, E-mail to: archives:>>> http://mail.webdna.us/list/talk@webdna.us Bug Reporting:>>> support@webdna.us>>>>>> --------------------------------------------------------- This=20>>message is>> sent to you because you are subscribed to the mailing list . To>> unsubscribe, E-mail to: archives:>> http://mail.webdna.us/list/talk@webdna.us Bug Reporting:>> support@webdna.us>>>> --------------------------------------------------------- This=20>>message is>> sent to you because you are subscribed to the mailing list . To>> unsubscribe, E-mail to: archives:>> http://mail.webdna.us/list/talk@webdna.us Bug Reporting:>> support@webdna.us>>>> --------------------------------------------------------- This=20>message is> sent to you because you are subscribed to the mailing list . To> unsubscribe, E-mail to: archives:> http://mail.webdna.us/list/talk@webdna.us Bug Reporting:=20>support@webdna.us>---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
321Because your sort is random. No two searches will be the same. It=20seemed to work the first time because it just didn't happen to find=20any of the previous ones. Please see my previous post and the followup=20by Lawrence.TerryOn Tue, 26 Apr 2016 10:31:41 -0500 Richard Kwasniewski wrote: Not sure what happened, it seemed like adding the "startat=3D7" didwork initially, but no more.... I may have missed matching up the items. =20 here is my search code.: =20 =20 [search db=3D^/rs/products.db&woSECTIONSdatarq=3D12&SECTIONSword=3Dww&namewbrk=3D=+&eqVisibledatarq=3DT&eqFeatureddatarq=3DYes&TITLEsort=3D1&TITLEsdir=3Dra=&max=3D6] [founditems] 6 random items shown..... [/founditems] [/search] =20 =20 Right beneath this I would have my 2nd search: =20 [search db=3D^/rs/products.db&woSECTIONSdatarq=3D12&SECTIONSword=3Dww&namewbrk=3D=+&eqVisibledatarq=3DT&eqFeatureddatarq=3DYes&TITLEsort=3D1&TITLEsdir=3Dra=] [founditems] Show all other items omitting the 6 found above.... [/founditems] [/search] =20 =20 All this takes place on the exact same page, so cookies don't seem=20tobe an option.... =20 Trying the text variable route.... if I add this within the 1stsearch [text show=3DT]found=3D[SKU][/text] shows me the SKUs of the 6 chosen randomly in that 1st search, buthow would I place all 6 of those SKUs within that 2nd search? =20 &neSKUdatarq=3D[found] is what I was thinking, but that can't work on=206SKUs =20 =20 =20 =20 On Tue, Apr 26, 2016 at 8:09 AM, Lawrence Banahan wrote: =20> Hi, you could also use a hidden input to keep the previous IDs and=20>exclude> them from next search> Lawrence>> 2016-04-26 14:57 GMT+02:00 Terry Wilson :>>> But you said you were searching for random results. I don't see how=20>>this>> would work.>>>> You could collect the record IDs from the first search in a cookie,=20>>and>> exclude those from the second search, or if on the same page, collect=20>>them>> in a text variable.>>>> Terry>>>> Sent from my iPad>>>> On Apr 26, 2016, at 5:17 AM, Richard Kwasniewski=20>>>> wrote:>>>> Well all righty...>>>> That "startat=3D7" seems to work just fine with that 2nd search/result=s=20>>etc.>>>> Thanks>>>>>> On Tue, Apr 26, 2016 at 6:53 AM, Tom Duke =20>>wrote:>>>>> Richard,>>>>>> Hi - if you have the same search and sorting criteria, then add:>>>>>> &startat=3D7>>>>>> to your second search.>>>>>> - Tom>>>>>>>>>>>> --------------------------------------------------------- This=20>>>message>>> is sent to you because you are subscribed to the mailing list . To>>> unsubscribe, E-mail to: archives:>>> http://mail.webdna.us/list/talk@webdna.us Bug Reporting:>>> support@webdna.us>>>>>> --------------------------------------------------------- This=20>>message is>> sent to you because you are subscribed to the mailing list . To>> unsubscribe, E-mail to: archives:>> http://mail.webdna.us/list/talk@webdna.us Bug Reporting:>> support@webdna.us>>>> --------------------------------------------------------- This=20>>message is>> sent to you because you are subscribed to the mailing list . To>> unsubscribe, E-mail to: archives:>> http://mail.webdna.us/list/talk@webdna.us Bug Reporting:>> support@webdna.us>>>> --------------------------------------------------------- This=20>message is> sent to you because you are subscribed to the mailing list . To> unsubscribe, E-mail to: archives:> http://mail.webdna.us/list/talk@webdna.us Bug Reporting:=20>support@webdna.us>---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
"Terry Wilson"
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:
[OT] Read and weep (2003)
PCS Frames (1997)
WebCat2 beta 11 - new prefs ... (1997)
Which GUI HTML editors work with WC ? (1997)
WebCat2 - [format thousands] (1997)
Credit Card Number checking (1997)
taxTotal, grandTotal (1997)
PCS Frames (1997)
Sorry, WebDNA Server Not Running! (2005)
IE Cache Problems... (1999)
Purchased cart being overwritten - still !?? (1997)
EmailProblem (2003)
Re[2]: Enhancement Request for WebCatalog-NT (1996)
Multiple catalog databases and showcart (1997)
Text limits in NT version? (1997)
PCS Frames (1997)
Nesting FoundItem Context (1997)
WebMerchant Error (1998)
Another question about credit cards (1997)
Error Log.db --however (1997)