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], and search/sort the table as needed. This is only possible if you're running WebDNA 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], and search/sort the table as needed. This is only possible if you're running WebDNA 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:
Passwords, Subscription, DBs, oh my! (2000)
turning every 5th line red (1999)
Re2: frames & carts (1997)
is sku a REQUIRED field on NT (1997)
Almost a there but..bye bye NetCloak (1997)
Was 5.0 Pricing, now Sandbox versus Website and ruminating (2003)
International Orders (1998)
RAIC and WebCAT (1999)
REPOST: WebCat & WebSTAR V (2002)
Help formatting search results w/ table (1997)
WebCatalog vs. Cold Fusion (1998)
[OT] DOD again *MYSTERY SOLVED* (2003)
Simple way to create unique SKU (1997)
Re:Signal Raised (1997)
Server problem? (1998)
headers (2000)
Problem with CC problem ? (1997)
[WebDNA] directory protection questions (2008)
5.0 tips etc (2003)
Problems with [Applescript] (1997)