Re: Special search
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21670
interpreted = N
texte = You could do something like this (where your first search is actually taking place inside of the second search context):[Search db=second.db&somecriteria&woSKUdatarq=[Search db=first.db&somecriteria][FoundItems][SKU] [/FoundItems][/Search]&SKUword=ww] [FoundItems] ... [/FoundItems] [/Search]Of course, this won't display list of SKUs, so if you want to do that you'd probably have to repeat the inner search.-Dave At 8:17 PM 12/8/98, Martin Gertz Bech wrote: >anybody any experience with making a serch which first will search a db for >a textstring and return all sku's and then continue the search in another >db and find the records that mathc the rest of the search criteria but only >find the once that also match the SKU field from the first db??? > > >/Martin > >Konsulentfirmaet Bech.dk >Dynamic HTML, WebDNA programming, Lasso & Filemaker Pro development o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+
Associated Messages, from the most recent to the oldest:
| |
- Re: Special search (Dave MacLeay 1998)
- Special search (Martin Gertz Bech 1998)
|
You could do something like this (where your first search is actually taking place inside of the second search context):[Search db=second.db&somecriteria&woSKUdatarq=[Search db=first.db&somecriteria]
[founditems][SKU] [/FoundItems][/Search]&SKUword=ww]
[founditems] ... [/FoundItems] [/Search]Of course, this won't display list of SKUs, so if you want to do that you'd probably have to repeat the inner search.-Dave At 8:17 PM 12/8/98, Martin Gertz Bech wrote: >anybody any experience with making a serch which first will search a db for >a textstring and return all sku's and then continue the search in another >db and find the records that mathc the rest of the search criteria but only >find the once that also match the SKU field from the first db??? > > >/Martin > >Konsulentfirmaet Bech.dk >Dynamic HTML, WebDNA programming, Lasso & Filemaker Pro development o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+
Dave MacLeay
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:
date (1999)
Multiple fields on 1 input (1997)
Location of Webcat site in folder hierarchy (1997)
Deleting Orders (1997)
WebCat2b12 - nesting [tags] (1997)
Multiple catalog databases and showcart (1997)
Solaris (2000)
WebDelivery downloads alias, not original ? (1997)
Converting native excel files (2001)
Quit revisited (1997)
problems with 2 tags (1997)
Setting up shop (1997)
Webstar 1.3.1 PPC (1997)
[shownext max=?] armed (1997)
Signal Raised Error (Part III) (1997)
Numbers from Sentence (2003)
RE: Help name our technology! (1997)
Using the sendmail command on CGate Pro (Unix) (2000)
How can I Add several Items into the cart at once? (1997)
Searching multiple fields (1997)