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:

Netscape v. IE (1997) RE: protect tag on NT (1997) How can I record purchases to a database? (1998) Press Release hit the NewsWire!!! (1997) creator code (1997) Setting up WebCatalog with Retail Pro data (1996) WebCatalog and WebMerchant reviewed by InfoWorld (1997) Re:Contest (1999) error: Too many nested [xxx] contexts (1997) Where can I download to test? (2003) Emailer (WebCat2) (1997) Extended [ConvertChars] (1997) [isfile] ? (1997) [WebDNA] try/except (2015) maximu values for sendmail! (1997) Email (1998) DON'T use old cart file! (1997) Encrypting the seed (2001) Search with Special Chars (1997) [SHOWIF AND/OR] (1997)