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 thesubcategory to be a related table listing all the subcategories that product canbelong to. A simplified example of this would be a piece of software (categoryEducational, for instance) that could be Mac, PC, or Unix, depending on what wasselected at time of purchase. So this item in the inventory.db would have acategory of Educational, and multiple subcategories of Mac, PC, andUnix. 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'dalso like a search for programs available on floppy to find this item, as wellas one for Educational Mac software on floppies. The customer selects a category for searching, then gets a search page with upto 3 popups to select (mutually independent) subcategories they are looking for.To do this, I need WebCatalog to search each subcategory database for all SKUsthat meet the criteria for each subcategory (ie Mac, CDROM) and AND the resultstogether (only SKUs with Mac and CDROM). I didn't see any documentation fordoing 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:

Re: searching multiple databases in single search (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997) Re: searching multiple databases in single search (Kenneth Grome 1997) 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?Our inventory can appear in several subcategories simultaneously so I'd like thesubcategory to be a related table listing all the subcategories that product canbelong to. A simplified example of this would be a piece of software (categoryEducational, for instance) that could be Mac, PC, or Unix, depending on what wasselected at time of purchase. So this item in the inventory.db would have acategory of Educational, and multiple subcategories of Mac, PC, andUnix. 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'dalso like a search for programs available on floppy to find this item, as wellas one for Educational Mac software on floppies. The customer selects a category for searching, then gets a search page with upto 3 popups to select (mutually independent) subcategories they are looking for.To do this, I need WebCatalog to search each subcategory database for all SKUsthat meet the criteria for each subcategory (ie Mac, CDROM) and AND the resultstogether (only SKUs with Mac and CDROM). I didn't see any documentation fordoing 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:

ConvertChars (2000) Drop Down Menus (2002) Adding Header Values with [SetHeader] (1998) More on the email templates (1997) Field name-subcategory (1997) [WebDNA] WebDNA version 7 feature list? (2011) why is this line in GeneralStore? (1998) Realtor Search (2000) syntax question, not in online refernce (1997) Displaying Location (1997) [urgent] Phone number at SM (2006) orders being printed (1998) PC site chck pls (2003) Urgent help needed (2003) WebDNA versus ASP [OT] (2002) When do we get to request new features? (1999) 2nd WebCatalog2 Feature Request (1996) Math, Multiple Equasions and Show/Hide (1998) [WebDNA] Help with iTools 9/WebDNA setup MacTel (2009) math problems (2000)