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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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)