Re: searching multiple databases in single search
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12757
interpreted = N
texte = <>Is it possible to have WebCatalog search multiple databases in a single>search?No, you need to do separate searches, one for each database. But all thesearches can be done from a single template, thus making it appear to theuser that they were all done as a single search.Just put several search contexts on the results page, one for eachsubcategory search you need to search. I do this all the time and it worksreally well ... :)>Thanks for the quick response. I have all the search context on a single pageand managed to use lookups to narrow the selection pretty quickly to match allsubcategory choices. Now I'm trying to handle the popup=All option (iechoosesub1=). I tried surrounding each [showif] with a pair of [hideif[choosesub1]=], and enclosing the [/showif/ with another [hideif[choosesub1]=] type pair but WebCatalog barfed. Should it have worked orshould it have barfed? If it won't work, looks like lots more IF scenarios tobe added to page.search for inventory within category and other criteria [founditems] [hideif [choosesub1]=] [showif [choosesub1]=[Lookupdb=searchsubclass1.db&lookInField=keyinventory1&value=[unique]&returnField=searchsub1]] [/hideif] [hideif [choosesub2]=] [showif [choosesub2]=[Lookupdb=searchsubclass2.db&lookInField=keyinventory2&value=[unique]&returnField=searchsub2]] [/hideif] [hideif [choosesub3]=] [showif [choosesub3]=[Lookupdb=searchsubclass3.db&lookInField=keyinventory3&value=[unique]&returnField=searchsub3]] [/hideif] (inventory info for records meeting search criteria)[hideif [choosesub1]=] [/showif] [/hideif] [hideif [choosesub2]=] [/showif] [/hideif] [hideif [choosesub3]=] [/showif] [/hideif] Thanks for the help!Sandy
Associated Messages, from the most recent to the oldest:
<>Is it possible to have WebCatalog search multiple databases in a single>search?No, you need to do separate searches, one for each database. But all thesearches can be done from a single template, thus making it appear to theuser that they were all done as a single search.Just put several search contexts on the results page, one for eachsubcategory search you need to search. I do this all the time and it worksreally well ... :)>Thanks for the quick response. I have all the search context on a single pageand managed to use lookups to narrow the selection pretty quickly to match allsubcategory choices. Now I'm trying to handle the popup=All option (iechoosesub1=). I tried surrounding each
[showif] with a pair of [hideif[choosesub1]=], and enclosing the [/showif/ with another [hideif[choosesub1]=] type pair but WebCatalog barfed. Should it have worked orshould it have barfed? If it won't work, looks like lots more IF scenarios tobe added to page.search for inventory within category and other criteria
[founditems] [hideif [choosesub1]=] [showif [choosesub1]=[Lookupdb=searchsubclass1.db&lookInField=keyinventory1&value=[unique]&returnField=searchsub1]] [/hideif] [hideif [choosesub2]=] [showif [choosesub2]=[Lookupdb=searchsubclass2.db&lookInField=keyinventory2&value=[unique]&returnField=searchsub2]] [/hideif] [hideif [choosesub3]=] [showif [choosesub3]=[Lookupdb=searchsubclass3.db&lookInField=keyinventory3&value=[unique]&returnField=searchsub3]] [/hideif] (inventory info for records meeting search criteria)[hideif [choosesub1]=] [/showif] [/hideif] [hideif [choosesub2]=] [/showif] [/hideif] [hideif [choosesub3]=] [/showif] [/hideif] Thanks for the help!Sandy
Sandra L. Pitner <76501.3521@CompuServe.COM>
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:
Search logic? (1998)
ANN: Strategic Partnership with BuyStream Announced. (2000)
RE: WebCatalog2 for NT Beta Request (1997)
New Plug-in and Type 11 errors (1997)
WebCat2 - Getting to the browser's username/password data (1997)
writefile - continued (1997)
Cart Number sequence (1997)
RE: WebCat name recognition (was MacFinder -- a new WebDNAweb site) (1998)
[WebDNA] Installing 6.0 onto Server 2008 (2011)
WebMerchant Config problems (2000)
apparent variable variable display? (2000)
[url] link (1998)
Form Variables (2000)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Misunderstanding?? (1997)
WebCat cannot handle compatible search parameters? (1997)
Initiating NewCart (1997)
SKU lookup (1997)
More on the email templates (1997)
More on the email templates (1997)