What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: [WebDNA] Nested Search

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101484
interpreted = N
texte = Figured it out ... There was a type in the second search request. Instead of %26 between the two arguments, it should have been an equal sign. Thanks! 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)
Figured it out ... There was a type in the second search request. Instead of %26 between the two arguments, it should have been an equal sign. Thanks! 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:

Line items in table cells (1997) If search results are blank... (2003) Sorting by number (2001) Replacing entry (1998) More on the email templates (1997) search problem (2002) Unexpected error (1997) [WebDNA] WebDNA on Linux (2009) Erotic Sites (1997) Bug Report, maybe (1997) This list needs a digest: rant, rave... (1997) Adding up weights (1998) Extended [ConvertChars] (1997) Duplicate Cart Numbers (1999) Help name our technology! (1997) PCS Frames (1997) A multi-processor savvy WebCatalog? (1997) shipcost (1997) Mime Headers for Mail (1998) Webmerchant turns off (2000)