Re: [WebDNA] Search 2 databases ???

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102542
interpreted = N
texte = Put the results of the 2 searches into a table and then you can search the table. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 12/05/2009, at 9:00 AM, Rich Kwas wrote: > > Is it possible to search 2 or more databases? > > NOT a nested search..... > > Something like > search database one, show it's results if any > search database two show its results if any etc. > > the same thing would be searched for in these multiple databases > > all done from one search form.... > > > > My reason for the question: > > I have a 4 year old community blogging type site where all the blog > entries are in "one" database. It's currently 30megs in size.... > > I'm pondering how to simply things for an upcoming update and > keeping stuff from 4 years ago with yesterdays entries seems > overkill. I can't say for sure if anyone even cares about blogs > entries from 4 years ago LOL. BUT I'd want to be able to have them > search the entire spectrum of entries if they want, which makes me > wonder if somehow having the entries stored in a "yearly" database > might be better.... > > > I suspect just keep the entries in one database is gonna be the best > way to continue. > > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Search 2 databases ??? (Rich Kwas 2009)
  2. Re: [WebDNA] Search 2 databases ??? ("Dan Strong" 2009)
  3. Re: [WebDNA] Search 2 databases ??? (Stuart Tremain 2009)
  4. [WebDNA] Search 2 databases ??? (Rich Kwas 2009)
Put the results of the 2 searches into a table and then you can search the table. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 12/05/2009, at 9:00 AM, Rich Kwas wrote: > > Is it possible to search 2 or more databases? > > NOT a nested search..... > > Something like > search database one, show it's results if any > search database two show its results if any etc. > > the same thing would be searched for in these multiple databases > > all done from one search form.... > > > > My reason for the question: > > I have a 4 year old community blogging type site where all the blog > entries are in "one" database. It's currently 30megs in size.... > > I'm pondering how to simply things for an upcoming update and > keeping stuff from 4 years ago with yesterdays entries seems > overkill. I can't say for sure if anyone even cares about blogs > entries from 4 years ago LOL. BUT I'd want to be able to have them > search the entire spectrum of entries if they want, which makes me > wonder if somehow having the entries stored in a "yearly" database > might be better.... > > > I suspect just keep the entries in one database is gonna be the best > way to continue. > > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ Stuart Tremain

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:

Sendmail doesn't (was Queertrons?) (1997) Does anyone have a solution to make carts smaller? (1998) Can this be done? (1997) method of payment (1997) WebCat2b15MacPlugin - showing [math] (1997) Byte Order Mark - removing via webcat? (2006) Setting up the server (1997) Problem with updating 2.1b7 -> 2.1.1 (1998) Add a field to the error log? (1997) [protect] on NT? (1997) StoreBuilder help/question... (2000) corrupted images (2002) IBM DB2 (2000) WebCat (or other) Indexing (1999) Erotic Sites (1997) Mozilla/4. and Browser Info.txt (1997) Some Questions (1997) Add to cart issue (2007) Database location (2002) SendMail - Idea (2000)