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:
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:
Newbie Tax Question (1997)
Comparing two fields so the match (1998)
Width & Height (1998)
Simple way to create unique SKU (1997)
Weird time (2001)
WebCat2b15MacPlugin - showing [math] (1997)
Hey .. so when are you guys (2004)
Superfilous Characters (1998)
Dummy Credit Card Number for debug? (1997)
[WebDNA] limit found per row (2011)
Laying an egg. (1998)
Emailer [cart] file names (1997)
Calculating multiple shipping... (1997)
Calculating days, hours, minutes ago (2004)
Site Test Please (2005)
ADD a product without Database (1998)
User/pass with tcpconnect (2000)
Poll Results (2002)
Less than or equal to........ (1997)
Newbie question (1998)