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 the searches can be done from a single template, thus making it appear to the user that they were all done as a single search.Just put several search contexts on the results page, one for each subcategory search you need to search. I do this all the time and it works really well ... :) >Thanks for the quick response. I have all the search context on a single page and managed to use lookups to narrow the selection pretty quickly to match all subcategory choices. Now I'm trying to handle the popup=All option (ie choosesub1=). 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 or should it have barfed? If it won't work, looks like lots more IF scenarios to be added to page.search for inventory within category and other criteria [founditems] [hideif [choosesub1]=] [showif [choosesub1]=[Lookup db=searchsubclass1.db&lookInField=keyinventory1&value=[unique]&returnField=search sub1]] [/hideif] [hideif [choosesub2]=] [showif [choosesub2]=[Lookup db=searchsubclass2.db&lookInField=keyinventory2&value=[unique]&returnField=search sub2]] [/hideif] [hideif [choosesub3]=] [showif [choosesub3]=[Lookup db=searchsubclass3.db&lookInField=keyinventory3&value=[unique]&returnField=search sub3]] [/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:

    
  1. Re: searching multiple databases in single search (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  2. Re: searching multiple databases in single search (Kenneth Grome 1997)
  3. searching multiple databases in single search (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
<>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 the searches can be done from a single template, thus making it appear to the user that they were all done as a single search.Just put several search contexts on the results page, one for each subcategory search you need to search. I do this all the time and it works really well ... :) >Thanks for the quick response. I have all the search context on a single page and managed to use lookups to narrow the selection pretty quickly to match all subcategory choices. Now I'm trying to handle the popup=All option (ie choosesub1=). 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 or should it have barfed? If it won't work, looks like lots more IF scenarios to be added to page.search for inventory within category and other criteria [founditems] [hideif [choosesub1]=] [showif [choosesub1]=[Lookup db=searchsubclass1.db&lookInField=keyinventory1&value=[unique]&returnField=search sub1]] [/hideif] [hideif [choosesub2]=] [showif [choosesub2]=[Lookup db=searchsubclass2.db&lookInField=keyinventory2&value=[unique]&returnField=search sub2]] [/hideif] [hideif [choosesub3]=] [showif [choosesub3]=[Lookup db=searchsubclass3.db&lookInField=keyinventory3&value=[unique]&returnField=search sub3]] [/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)