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:
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)