searching multiple databases in single search
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12752
interpreted = N
texte = Is it possible to have WebCatalog search multiple databases in a single search? Our inventory can appear in several subcategories simultaneously so I'd like the subcategory to be a related table listing all the subcategories that product can belong to. A simplified example of this would be a piece of software (category Educational, for instance) that could be Mac, PC, or Unix, depending on what was selected at time of purchase. So this item in the inventory.db would have a category of Educational, and multiple subcategories of Mac, PC, and Unix. There's also other subcategories for this item (such as CDROM, floppy, download,etc.) We'd like a search for Mac Software to find this item. We'd also like a search for programs available on floppy to find this item, as well as one for Educational Mac software on floppies. The customer selects a category for searching, then gets a search page with up to 3 popups to select (mutually independent) subcategories they are looking for.To do this, I need WebCatalog to search each subcategory database for all SKUs that meet the criteria for each subcategory (ie Mac, CDROM) and AND the results together (only SKUs with Mac and CDROM). I didn't see any documentation for doing this. Nesting searches is getting pretty messy fast. Is there a better way?Thanks in advance!Sandy
Associated Messages, from the most recent to the oldest:
Is it possible to have WebCatalog search multiple databases in a single search? Our inventory can appear in several subcategories simultaneously so I'd like the subcategory to be a related table listing all the subcategories that product can belong to. A simplified example of this would be a piece of software (category Educational, for instance) that could be Mac, PC, or Unix, depending on what was selected at time of purchase. So this item in the inventory.db would have a category of Educational, and multiple subcategories of Mac, PC, and Unix. There's also other subcategories for this item (such as CDROM, floppy, download,etc.) We'd like a search for Mac Software to find this item. We'd also like a search for programs available on floppy to find this item, as well as one for Educational Mac software on floppies. The customer selects a category for searching, then gets a search page with up to 3 popups to select (mutually independent) subcategories they are looking for.To do this, I need WebCatalog to search each subcategory database for all SKUs that meet the criteria for each subcategory (ie Mac, CDROM) and AND the results together (only SKUs with Mac and CDROM). I didn't see any documentation for doing this. Nesting searches is getting pretty messy fast. Is there a better way?Thanks in advance!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:
Another question about credit cards (1997)
RAM variables (1997)
Bug in v5.1? (2003)
with Link i need to (1997)
Location of Webcat site in folder hierarchy (1997)
Help name our technology! (1997)
[WebDNA] WebDNA on Linux (2009)
[WebDNA] How to Combine a search with Webdna and JS (2017)
2nd try: possible to weight results of grouped fieldssearch? (1998)
Passing info in [Addlineitem] (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
Mac & Internet Explorer (2000)
Configuring E-mail (1997)
Help formatting search results w/ table (1997)
ODBC problems between webcatalog and filemaker pro (2001)
RE: type 2 errors with ssl server (1997)
2nd WebCatalog2 Feature Request (1996)
Help!!!! (1999)
Shopping carts and reloading pages (1997)
default value from Lookup (was Grant, please help me) (1997)