Re: Search Multiple databases
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 60727
interpreted = N
texte = Your only go will be a search in a search with WebDNA db's. You c= an only do this with SQL and to join db's. Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=C2=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B= ehalf Of > Eric Miller > Sent: Dienstag, 11. Januar 2005 22:55 > To: WebDNA Talk > Subject: Search Multiple databases > > Is there a way to search multiple databases, that have un-relat= ed fields, > in a single search statement? We have a database that gets FTPe= d 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=20= new one we > are going to add. But these records are not related at all. Is=20= there a way > to search db1 & db2 inside the same [search][/search] context.=20= 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. > > > Thanks in advance, > Eric Miller > Web Developer > The GoTriCities Network > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.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:
Your only go will be a search in a search with WebDNA db's. You c= an only do this with SQL and to join db's. Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=C2=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B= ehalf Of > Eric Miller > Sent: Dienstag, 11. Januar 2005 22:55 > To: WebDNA Talk > Subject: Search Multiple databases > > Is there a way to search multiple databases, that have un-relat= ed fields, > in a single search statement? We have a database that gets FTPe= d 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=20= new one we > are going to add. But these records are not related at all. Is=20= there a way > to search db1 & db2 inside the same [search][/search] context.=20= 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. > > > Thanks in advance, > Eric Miller > Web Developer > The GoTriCities Network > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.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/
"Nitai @ ComputerOil"
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:
[DOS] (1999)
Need relative path explanation (1997)
CloseDataBase vs CommitDataBase (2007)
[include] affect on filepaths for links? (1997)
notification solutions (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
Can this be done? (1997)
WebCatalog for guestbook ? (1997)
WebCat2final1 crashes (1997)
Setting up WebCatalog with Retail Pro data (1996)
The Form authentication trick (2000)
Prevent multiple appends with Reload Button (1997)
!@#$$@@# formulas database, tax and freight. (2002)
[OT] Server check please (2006)
synching databases on multiple servers (1997)
process code only if accessed via POST (2006)
Ampersands in database fields? (1998)
[Announce]: Web server security and password protection (1997)
WCS Newbie question (1997)
Sizes and colors (1999)