Re: Searching multiple databases

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21957
interpreted = N
texte = >Database A >sku color size >1 blue m >2 green m >3 white m > >Database B >sku material texture price >1 cotton smooth 18 >2 silk ribbed 15 >3 silk smooth 15>Is it possible to somehow nest this search?Yes, but I would NOT nest them, instead I would do them in sequence, it's probably faster than nesting.>How would I structure the searches?Perform a search on db=A first, then create a variable called [skuList] to use in your search on db=B. Here's an example:[search db=B&eqmaterialdatarq=silk&eqtexturedatarq=smooth&woskudatarq=[skuList]] [founditems] Results matching *both* searches will appear here ... [/founditems] [/search]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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)
>Database A >sku color size >1 blue m >2 green m >3 white m > >Database B >sku material texture price >1 cotton smooth 18 >2 silk ribbed 15 >3 silk smooth 15>Is it possible to somehow nest this search?Yes, but I would NOT nest them, instead I would do them in sequence, it's probably faster than nesting.>How would I structure the searches?Perform a search on db=A first, then create a variable called [skuList] to use in your search on db=B. Here's an example:[search db=B&eqmaterialdatarq=silk&eqtexturedatarq=smooth&woskudatarq=[skuList]] [founditems] Results matching *both* searches will appear here ... [/founditems] [/search]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

stuck time (1998) Type 11 errors setting up WebCAt 2 (1997) [WebDNA] WebDNA jQuery JSON javascript stuff (2010) Add Unit Ship Cost to Cart (2000) Webcat 4.0 and security (2000) Emailer choke (1997) Reloading adds items - how to prevent?? (1998) Problems passing [SKU] with $Replace in 2.0 (1997) sorting question... (2001) RE: Automatic thumbnail images (1998) Calculating multiple shipping... (1997) question: webmerchant connection (1997) WebCat editing, SiteGuard & SiteEdit (1997) For those of you not on the WebCatalog Beta... (1997) question: back button prevention (1997) webcat feature request (1997) WebCatalog and Filemaker (1996) Some Questions (1997) Tab Charactor (1997) Cookies (1999)