Re: Search Multiple databases

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60725
interpreted = N
texte = On Jan 11, 2005, at 1:55 PM, Eric Miller wrote: > Is there a way to search multiple databases, that have un-related > fields, in a single search statement? We have a database that gets > FTPed up to a site each week and now we are going to be adding an > additional database(not via FTP) that will contain similar information > but none of the records of each will be related. > > For example, one database has a Stock Number field as does the new one > we are going to add. But these records are not related at all. Is > there a way to search db1 & db2 inside the same [search][/search] > context. I know about doing a search inside of a search, but I need > the ability to search both at the same time for specific values. There is no way to do this with built in WebDNA databases. SQL might be useful here but I'm not sure if it will work with unrelated data. -- Jesse Williams-Proudman Blue Box Development :: Custom Web Solutions +1 (206) 347-0528 :: jesse@blueboxdev.com ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Search Multiple databases ( "Eric Miller" 2005)
  2. Re: Search Multiple databases ( "Nitai @ ComputerOil" 2005)
  3. Re: Search Multiple databases ( Clint Davis 2005)
  4. Re: Search Multiple databases ( Jesse Proudman 2005)
  5. Search Multiple databases ( "Eric Miller" 2005)
On Jan 11, 2005, at 1:55 PM, Eric Miller wrote: > Is there a way to search multiple databases, that have un-related > fields, in a single search statement? We have a database that gets > FTPed up to a site each week and now we are going to be adding an > additional database(not via FTP) that will contain similar information > but none of the records of each will be related. > > For example, one database has a Stock Number field as does the new one > we are going to add. But these records are not related at all. Is > there a way to search db1 & db2 inside the same [search][/search] > context. I know about doing a search inside of a search, but I need > the ability to search both at the same time for specific values. There is no way to do this with built in WebDNA databases. SQL might be useful here but I'm not sure if it will work with unrelated data. -- Jesse Williams-Proudman Blue Box Development :: Custom Web Solutions +1 (206) 347-0528 :: jesse@blueboxdev.com ------------------------------------------------------------- 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://webdna.smithmicro.com/ Jesse Proudman

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:

problems with 2 tags shakur (1997) Speed/performance issues using .hdr (1997) Web Developer Product Awards (1997) fixed date problem (1997) [WebDNA] [ReturnRaw] problem (2010) PIXO Support (1997) Re1000001: Setting up shop (1997) Setting up WebCatalog with Retail Pro data (1996) Almost a there but..bye bye NetCloak (1997) WebDNA Developer Resource Center (2002) Silly Question (2003) [ShowIf] if the varieable exists (1998) WebTV, IPAddress, Cookies, IDEAS?? (1998) Caching pages...again (2001) Sendmail Recipients (2001) [isfile] ? (1997) Problems getting parameters passed into email. (1997) WebCat2 - [format thousands] (1997) HideIf ip= OR ip (1998) oops private message leaked into talk list (1997)