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:

A better WebCat whois (was [OT] Domain Name Scam) (2000) Calculating multiple shipping... (1997) RE: Formulas.db + Users.db (1997) add to cart within a page? (1997) PCS Frames (1997) Search in 2 or more catalogs (1997) [sendmail] questions... (1997) ISAPI WC6a and Windows 2003 Web Edition (2006) Error Lob.db records error message not name (1997) docs for WebCatalog2 (1997) ODBC problems between webcatalog and filemaker pro (2001) New public beta available (1997) Bug in 4.5 - Needs to be fixed ASAP. (2002) Kaaaaahhhhhhhnnnnnnn! (1997) WebDNA Life Cycle (2007) send mail problem? (1997) 2.1b2 was SLOW ... but 2.1b3 is FAST! (1997) WebCat control of Print (2001) tracking no. of downloads (2006) Spawning Holdup? (2000)