Re: [WebDNA] Nested Search

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101482
interpreted = N
texte = --=====================_435295046==.ALT Content-Type: text/plain; charset="us-ascii" To be sure, you can set the [numfound] from the inner search to a text variable - [search db=^db/products.db&eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]] [text show=f]THISFIND=[numfound][/text] [showif [THISFIND]>100]....[/showif] At 09:37 AM 11/20/2008, you wrote: >I'm trying to generate a link to similar items from our item detail page. > >Currently, our item detail page is generated by doing a search on our products database for the sku and passing that sku to a search request: > >[search db=^db/products.db&eqSKUdatarq=[s]] > >Once inside of this search, I want to do a second search for items that have the same categories as the found item. If the numfound is greater than 100, I want to automatically create a link with 3 categories. If the numfound is less than 100, I want to automatically create a link with only 2 categories: > >[search db=^db/products.db&eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]] > [showif [numfound]>100] >See similar items (includes cat 3) >[/showif] > >[showif [numfound]<100] > See similar items (does not include cat 3) >[/showif] > >[/search] > >The problem is, I think since this search is being done within the first search context, the numfound is always going to be 1. > >How can I do this so that this search is independent of the first search, but is still able to use the categories of the sku found in the first search? --=====================_435295046==.ALT Content-Type: text/html; charset="us-ascii" To be sure, you can set the [numfound] from the inner search to a text variable -

[search db=^db/products.db&eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]]
[text show=f]THISFIND=[numfound][/text]

[showif [THISFIND]>100]....[/showif]

At 09:37 AM 11/20/2008, you wrote:
I'm trying to generate a link to similar items from our item detail page.

Currently, our item detail page is generated by doing a search on our products database for the sku and passing that sku to a search request:

[search db=^db/products.db&eqSKUdatarq=[s]]

Once inside of this search, I want to do a second search for items that have the same categories as the found item. If the numfound is greater than 100, I want to automatically create a link with 3 categories. If the numfound is less than 100, I want to automatically create a link with only 2 categories:

[search db=^db/products.db&eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]]
        [showif [numfound]>100]
<a href=" http://www.knifecenter.com/kc_new/store_store.html?ttl=KNIFECENTER%20LISTINGS&amp;srch=eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]%26eqWWWCAT_3datarq%3D[WWWCAT_3 ]">See similar items (includes cat 3)</a>
[/showif]

[showif [numfound]<100]
        <a href="http://www.knifecenter.com/kc_new/store_store.html?ttl=KNIFECENTER%20LISTINGS&amp;srch=eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]">See similar items (does not include cat 3)</a>
[/showif]

[/search]

The problem is, I think since this search is being done within the first search context, the numfound is always going to be 1.

How can I do this so that this search is independent of the first search, but is still able to use the categories of the sku found in the first search?
--=====================_435295046==.ALT-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Nested Searches (Stephen Braun 2013)
  2. Re: [WebDNA] Nested Searches (WebDNA 2013)
  3. Re: [WebDNA] Nested Searches ("Brian B. Burton" 2013)
  4. Re: [WebDNA] Nested Searches (Eddie Z 2013)
  5. Re: [WebDNA] Nested Searches (Stephen Braun 2013)
  6. Re: [WebDNA] Nested Searches ("Terry Wilson" 2013)
  7. Re: [WebDNA] Nested Searches (Stuart Tremain 2013)
  8. Re: [WebDNA] Nested Searches (Stephen Braun 2013)
  9. RE: [WebDNA] Nested Searches ("Gary Krockover" 2013)
  10. RE: [WebDNA] Nested Searches ("Terry Nair" 2013)
  11. [WebDNA] Nested Searches (Stephen Braun 2013)
  12. Re: [WebDNA] Nested Search (Ki Song 2008)
  13. Re: [WebDNA] Nested Search (Ki Song 2008)
  14. Re: [WebDNA] Nested Search (Gary Krockover 2008)
  15. [WebDNA] Nested Search (Ki Song 2008)
--=====================_435295046==.ALT Content-Type: text/plain; charset="us-ascii" To be sure, you can set the [numfound] from the inner search to a text variable - [search db=^db/products.db&eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]] [text show=f]THISFIND=[numfound][/text] [showif [THISFIND]>100]....[/showif] At 09:37 AM 11/20/2008, you wrote: >I'm trying to generate a link to similar items from our item detail page. > >Currently, our item detail page is generated by doing a search on our products database for the sku and passing that sku to a search request: > >[search db=^db/products.db&eqSKUdatarq=[s]] > >Once inside of this search, I want to do a second search for items that have the same categories as the found item. If the numfound is greater than 100, I want to automatically create a link with 3 categories. If the numfound is less than 100, I want to automatically create a link with only 2 categories: > >[search db=^db/products.db&eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]] > [showif [numfound]>100] >See similar items (includes cat 3) >[/showif] > >[showif [numfound]<100] > See similar items (does not include cat 3) >[/showif] > >[/search] > >The problem is, I think since this search is being done within the first search context, the numfound is always going to be 1. > >How can I do this so that this search is independent of the first search, but is still able to use the categories of the sku found in the first search? --=====================_435295046==.ALT Content-Type: text/html; charset="us-ascii" To be sure, you can set the [numfound] from the inner search to a text variable -

[search db=^db/products.db&eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]]
[text show=f]THISFIND=[numfound][/text]

[showif [THISFIND]>100]....[/showif]

At 09:37 AM 11/20/2008, you wrote:
I'm trying to generate a link to similar items from our item detail page.

Currently, our item detail page is generated by doing a search on our products database for the sku and passing that sku to a search request:

[search db=^db/products.db&eqSKUdatarq=[s]]

Once inside of this search, I want to do a second search for items that have the same categories as the found item. If the numfound is greater than 100, I want to automatically create a link with 3 categories. If the numfound is less than 100, I want to automatically create a link with only 2 categories:

[search db=^db/products.db&eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]]
        [showif [numfound]>100]
<a href=" http://www.knifecenter.com/kc_new/store_store.html?ttl=KNIFECENTER%20LISTINGS&amp;srch=eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]%26eqWWWCAT_3datarq%3D[WWWCAT_3 ]">See similar items (includes cat 3)</a>
[/showif]

[showif [numfound]<100]
        <a href="http://www.knifecenter.com/kc_new/store_store.html?ttl=KNIFECENTER%20LISTINGS&amp;srch=eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]">See similar items (does not include cat 3)</a>
[/showif]

[/search]

The problem is, I think since this search is being done within the first search context, the numfound is always going to be 1.

How can I do this so that this search is independent of the first search, but is still able to use the categories of the sku found in the first search?
--=====================_435295046==.ALT-- Gary Krockover

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:

[Middle] Probs with "&" (2003) CommandSecurity? (1997) emailer settings and control questions (1997) Where is the secure setting for text variables? (2003) Re:[ShowIf] and empty fields (1997) WebCat2 - Getting to the browser's username/password data (1997) [OT] DNS Problems (2004) Modifying order output (1997) WC2.0 Memory Requirements (1997) method of payment (1997) Re:What file? (1997) RE: Re:Has this happened to you? (1997) WebDNA Developer Resource Center (2002) Email problem.. (2004) Using the W* upload p-i with webcat (1998) emailcompleted and emailproblem folders (2005) WC2f3 (1997) Moving Files (2000) Math (1997) Nested tags count question (1997)