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 using SQL) is by using nested queries. Your second paragraph above has the right 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 criteria for 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:

    
  1. Re: Multiple database search q -- Web Catalog 2.1 (John Peacock 2000)
  2. Multiple database search q -- Web Catalog 2.1 (Christopher Feyrer 2000)
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 using SQL) is by using nested queries. Your second paragraph above has the right 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 criteria for 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)