Re: Multiple database search q -- Web Catalog 2.1
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35885
interpreted = N
texte = Christopher Feyrer wrote:> > [snip]>> Searching by both is proving to be extremely tricky, however, because it> seems impossible to set both variables in a second search because of the> lack of the [text] context in WebCat 2.1.> > One workaround was to do a search for category in the ad database, and then> do a showif which displays only if the city matches the input city; but> this threw off my founditems.> > Any ideas are welcome!> > Christopher Feyrer> Christopher - The only way that WebCatalog can perform multi-table queries (not usingSQL) is by using nested queries. Your second paragraph above has theright method: search by category then search by city within that query.For example:[search db=table1&eqFIELD1data=stuff][!]OUTFIELD from here[/!] [search db=table2&eqFIELD2datarq=otherstuff&eqFIELD3datarq=[OUTFIELD]] [founditems] [!]only displayed if both searches succeed[/!]...You should get the idea; the outer query supplies part of the criteriafor the inner query. Feel free to put [url] around any field which might contain spaces/ampersands/etc.HTHJohn Peacock-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Christopher Feyrer wrote:> > [snip]>> Searching by both is proving to be extremely tricky, however, because it> seems impossible to set both variables in a second search because of the> lack of the [text] context in WebCat 2.1.> > One workaround was to do a search for category in the ad database, and then> do a showif which displays only if the city matches the input city; but> this threw off my founditems.> > Any ideas are welcome!> > Christopher Feyrer> Christopher - The only way that WebCatalog can perform multi-table queries (not usingSQL) is by using nested queries. Your second paragraph above has theright method: search by category then search by city within that query.For example:[search db=table1&eqFIELD1data=stuff][!]OUTFIELD from here[/!] [search db=table2&eqFIELD2datarq=otherstuff&eqFIELD3datarq=[OUTFIELD]] [founditems] [!]only displayed if both searches succeed[/!]...You should get the idea; the outer query supplies part of the criteriafor the inner query. Feel free to put [url] around any field which might contain spaces/ampersands/etc.HTHJohn Peacock-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Peacock
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:
Limitations on fields? Server is crashing (1997)
[lineitems] (2000)
webcat- multiple selection in input field (1997)
AUTONUMBER (2003)
[WebDNA] Sorry WebDNA server not running (2014)
Re:Help name our technology! (1997)
Syntax of a URL for including ?cart=[cart] and #something? (1998)
Webmerchant confirmation hooks? (1997)
Emailer help....! (1997)
Email within tmpl ? (1997)
Hide Cart ID in URL? (2003)
Any way to index the contents of a PDF file with WebCatalog? (2000)
Shopping Carts folder does not exist in Linux (2000)
Q: Linux WebCat to ODBC (2001)
Access file on a remote server (2003)
Bug? (1997)
Not really WebCat (1997)
[WebDNA] Help with STMP Setup using Authentication with Google Apps in WebDNA (2016)
WebCat2: Items xx to xx shown, etc. (1997)
BBEdit and WebCatalog 2.0? (1997)