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:

[OT] MS Security Flaw (2000) Erotic Sites (1997) PCS Frames-Default page is solution! (1997) [OT] Disable/enable field (2003) 5.0 tips etc (2003) Shipping.db (1998) [TaxableTotal] - not working with AOL and IE (1997) Random question (1998) WebCatalog can't find database (1997) Searching for a space (2000) RAM variables (1997) Targeted Redirect (1999) can WC render sites out? (1997) unique ascending numbers (2003) Hard Questions ? (1997) Today's suggestions (1998) Major bug report on rootbeer (1997) WebCatalog complains that the service is not running. (1998) PCS Emailer's role ? (1997) Sort Order on a page search (1997)