[WebDNA] Search 2 databases ???

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102541
interpreted = N
texte = 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. 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)
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. Rich Kwas

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:

FEATURE REQUEST: Auto Resizing of images (2002) Search design (1997) Loops and [index] (1998) WebCat2: Master Counter snippet (1997) Sendmail: bounced e-mails (2001) OT: Quick poll (2003) Line items in table cells (1997) PCS Frames (1997) [OT] Adopting out a WebDNA website (2003) Title not showing up in ViewOrder template (1998) SMSI, please respond: Unanswered trigger questions ... (2003) math problems (2000) [WebDNA] sort parameters in search (2015) HTML Editors (1997) adding second sku (2000) WebCatalog2 Feature Feedback (1996) emailer on Windows Beta 18 (1997) [WebDNA] Processor Maxing out (2010) Searching multiple criteria (2000) Help! WebCat2 bug (1997)