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:

More on the email templates (1997) Extended [ConvertChars] (1997) Online reference (1997) Dark Horse Comics success story (1997) WCS Newbie question (1997) Help!HELP!HELP! (1999) [WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010) Customer (1998) Database monitoring (2005) [WebDNA] Friday's.. WIP thread (2009) looping table rows (1999) WebCat2: Formulas.db question (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) encrypted query string trouble on OSX (2001) For those of you not on the WebCatalog Beta... (1997) using showpage and showcart commands (1996) Problems getting parameters passed into email. (1997) [WebDNA] Mac Question (2018) bug in [SendMail] (1997) multi-paragraph fields (1997)