Re: Search Multiple databases
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 60726
interpreted = N
texte = Short answer: NO.But, you could search each database, add the found records to a [table], andsearch/sort the table as needed. This is only possible if you're runningWebDNA 5.0+On 1/11/05 3: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.-------------------------------------------------------------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:
Short answer: NO.But, you could search each database, add the found records to a [table], andsearch/sort the table as needed. This is only possible if you're runningWebDNA 5.0+On 1/11/05 3: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.-------------------------------------------------------------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/
Clint Davis
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:
[showif] and equality (1998)
Frames and WebCat (1997)
4.5 buglist (2002)
Date problem still... (2004)
Listserver problem (1997)
Stopping bad HTML propagation ? (1997)
[SearchString] problem with [search] context (1997)
PCSDecrypt bugs still unfixed ... (2000)
[numfound] within summ=t (2000)
products db philosophy (2001)
Numbers and Numbers and Me (1999)
Include a big block of text (1997)
WebCat2 several catalogs? (1997)
[defined]ish (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
RE: Languages (1997)
[WebDNA] First-timer feedback (2014)
Price Not Appearing (2000)
Email notification to one of multiple vendors ? (1997)
Problems appending to database (1997)