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:

WC2.0 Memory Requirements (1997) Problems with [Applescript] (1997) Textarea Breaks (2000) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) HELP WITH DATES (1997) [WebDNA] WebDNA 7 (2011) [convertChars] and HTML Tags (1997) Summing fields (1997) Search Command, multiple dbs, etc. --still confused (2000) OT: javascript help (2003) How To get Some Help (2003) Bug or syntax error on my part? (1997) What am I missing (1997) Pull Down Search (2000) Stopping bad HTML propagation ? (1997) Probably a very simple question? (1997) WebCommerce: Folder organization ? (1997) Day of the week (2006) WCS Newbie question (1997) + character mystery (2003)