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:
View order not right (1997)
File not found error message (1998)
WebDNA Life Cycle (was Form POSTing with LONG variable) (2007)
[OT] Industry standard for missing orders (2003)
problem serving foreign languages text (1997)
Uh...can someone help me out with the b10? (1997)
Large database on Mac OS X Server (2000)
What's New Date (2002)
Command=Showcart? (2000)
Upgrading old WebCat Database Files (1997)
PCS Frames (1997)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
Number searching/formats (1998)
Purchased cart being overwritten - still !?? (1997)
database size? (1997)
WebCatalog Install Problem (2005)
Search/sort in URL Was: GuestBook example (1997)
Solution: Replace/Commit not Replacing/Commiting (2000)
WebCat cannot handle compatible search parameters? (1997)
New Command prefs ... (1997)