Re: [WebDNA] Nested Search

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101483
interpreted = N
texte = Weird ... Doing it the way that I originally coded it and the way that Gary suggested, the numfound comes out to 0, not 1. Gary Krockover wrote: > 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] >> > href="http://www.knifecenter.com/kc_new/store_store.html?ttl=KNIFECENTER%20LISTINGS&srch=eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]">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? 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)
Weird ... Doing it the way that I originally coded it and the way that Gary suggested, the numfound comes out to 0, not 1. Gary Krockover wrote: > 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] >> > href="http://www.knifecenter.com/kc_new/store_store.html?ttl=KNIFECENTER%20LISTINGS&srch=eqWWWCAT_1datarq%3D[WWWCAT_1]%26eqWWWCAT_2datarq%3D[WWWCAT_2]">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? Ki Song

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:

filemaker - orderfile (1997) Help! WebCat2 bug (1997) RE: Multiple Stores and WebCatalog Prefs (1997) Mass-mailer options - any suggestions ? (2005) [WebDNA] Bullet proof dynamic tables (2009) [ShowNext] (1997) Including encrypted templates ... ? (2003) textarea question (1998) Some Advise needed (1997) problem serving foreign languages text (1997) OT: Poll Results (2002) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) FEW QUESTIONS (1997) FW: Shipping calculations (1997) CPU Usage 165% (2005) php vs WebCatalog (2000) [GROUPS] followup (1997) Sorting problem (1997) FoxPro & WebDNA (2006) BUG REPORT: Delete context ignores max parameter (1998)