[WebDNA] Nested Search
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101481
interpreted = N
texte = 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?
Associated Messages, from the most recent to the oldest:
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?
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:
protect tag on NT IIS (1997)
find with exceptions (1997)
[slightly OT] WebCat vs. WebObjects ;) (2000)
losing serial number - help! (1998)
[carts] and databases (1997)
text size limitation (1997)
Formatting a .txt file (1998)
sort without the or a (1998)
Followup question re: checksum for credit cards? (1997)
Displaying Location (1997)
[WebDNA] Brian Harrington (2019)
Include a big block of text (1997)
New public beta available (1997)
test (2008)
Max Record length (1997)
Re[3]: Weird [blank] interpretation (1999)
WebCatalog for Postcards ? (1997)
Include from DB (2002)
docs for WebCatalog2 (1997)
Grant, please help me ... (1997)