Searching multiple databases

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21955
interpreted = N
texte = I need to construct a search through multiple databases and come up with a list of items that returntrue if the conditions of both searches are met. My actual searches are pretty complex (both inner and outer) involving dates and group searches etc. so I've created a simple example for illustration: Database A sku color size 1 blue m 2 green m 3 white mDatabase B sku material texture price 1 cotton smooth 18 2 silk ribbed 15 3 silk smooth 15Now, what I need is to search for all records that are the size m but not the color green in database A and also have a smooth texture and made of silk and a price of less than 16 which are values stored in database B and then return that list of skus. So in this case my result would be sku #3.Is it possible to somehow nest this search? If so, how would I structure the searches? If not what technique would I emply to make this work? Thanks in advance Marty Schmid Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching Multiple Databases (Eric palhof 2000)
  2. Re: Searching Multiple Databases (Kenneth Grome 2000)
  3. Re: Searching Multiple Databases (Eric palhof 2000)
  4. Re: Searching Multiple Databases (WebDNA Support 2000)
  5. Re: Searching Multiple Databases (Eric palhof 2000)
  6. Re: Searching Multiple Databases (WebDNA Support 2000)
  7. Searching Multiple Databases (Eric palhof 2000)
  8. Re: Searching multiple databases (Kenneth Grome 1998)
  9. Re: Searching multiple databases (Kenneth Grome 1998)
  10. Searching multiple databases (Marty Schmid 1998)
  11. Re: searching multiple databases (Kenneth Grome 1997)
  12. Re: searching multiple databases (Brian B. Burton 1997)
  13. Re: searching multiple databases (Raymond Hatch 1997)
  14. Re: searching multiple databases (Kenneth Grome 1997)
  15. Re: searching multiple databases (Grant Hulbert 1997)
  16. searching multiple databases (Raymond Hatch 1997)
  17. Re: searching multiple databases in single search (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  18. Re: searching multiple databases in single search (Kenneth Grome 1997)
  19. searching multiple databases in single search (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  20. Re: Searching multiple Databases (John Hill 1997)
  21. Re: Searching multiple Databases (Grant Hulbert 1997)
  22. Searching multiple Databases (Michael Winston 1997)
I need to construct a search through multiple databases and come up with a list of items that returntrue if the conditions of both searches are met. My actual searches are pretty complex (both inner and outer) involving dates and group searches etc. so I've created a simple example for illustration: Database A sku color size 1 blue m 2 green m 3 white mDatabase B sku material texture price 1 cotton smooth 18 2 silk ribbed 15 3 silk smooth 15Now, what I need is to search for all records that are the size m but not the color green in database A and also have a smooth texture and made of silk and a price of less than 16 which are values stored in database B and then return that list of skus. So in this case my result would be sku #3.Is it possible to somehow nest this search? If so, how would I structure the searches? If not what technique would I emply to make this work? Thanks in advance Marty Schmid Marty Schmid

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:

[subtotal] problems -- help? (1998) What's wrong with this [append] context? (2000) WebSite and *NO* Authentication Dialog Box!!? (1998) Multiple prices (1997) 5.0 Pricing (2003) Re:ListFields and [name] (1997) Why does WebCat do this? (2001) # of real domains on 1 web server (1997) RE: completed orders database (1997) [ListFiles] & [loop] (1998) [ot] What'd you all get me for my birthday? ;) (2003) wc 2 pro users - sites, quotes wanted (1997) [OT] DOD again *MYSTERY SOLVED* (2003) Using [Include] Context (1999) Protect vs Authenicate (1997) Template Cache problem -- new plugin for ya' (2000) How do I send a 404 HTTP header ? (2004) shownext & math (1997) OT: Amazon Patents (2000) db access problem after switching to SSL (2001)