Re: [WebDNA] Search 2 databases ???

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102543
interpreted = N
texte = I apologize ahead of time if I misunderstand, but here goes (totally goin= g shorthand to give you=20 the gist):
[table name=3DtheSearchResultsTable&fields=3DsomeID,searchTerm] [/table] [search database #1..] [founditems] [append table=3DtheSearchResultsTable..][/append] [/founditems] [/search] [search database #2..] [founditems] [append table=3DtheSearchResultsTable..][/append] [/founditems] [/search] etc. [search table=3DtheSearchResultsTable..] [founditems] ...show your results here ... [/founditems] [/search] -Dan On Mon, 11 May 2009 16:00:50 -0700 (PDT) Rich Kwas wrote: >=20 > Is it possible to search 2 or more databases? >=20 > NOT a nested search.....=20 >=20 > Something like=20 > search database one, show it's results if any > search database two show its results if any etc. >=20 > the same thing would be searched for in these multiple databases >=20 > all done from one search form.... >=20 >=20 >=20 > My reason for the question: >=20 > I have a 4 year old community blogging type site where all the blog ent= ries are in "one"=20 >database. It's currently 30megs in size.... >=20 > I'm pondering how to simply things for an upcoming update and keeping s= tuff from 4 years ago=20 >with yesterdays entries seems overkill. I can't say for sure if anyone e= ven cares about blogs=20 >entries from 4 years ago LOL. BUT I'd want to be able to have them searc= h the entire spectrum of=20 >entries if they want, which makes me wonder if somehow having the entrie= s stored in a "yearly"=20 >database might be better.... >=20 >=20 > I suspect just keep the entries in one database is gonna be the best wa= y to continue. >=20 >=20 >=20 > =20 > --------------------------------------------------------- > 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)
I apologize ahead of time if I misunderstand, but here goes (totally goin= g shorthand to give you=20 the gist):
[table name=3DtheSearchResultsTable&fields=3DsomeID,searchTerm] [/table] [search database #1..] [founditems] [append table=3DtheSearchResultsTable..][/append] [/founditems] [/search] [search database #2..] [founditems] [append table=3DtheSearchResultsTable..][/append] [/founditems] [/search] etc. [search table=3DtheSearchResultsTable..] [founditems] ...show your results here ... [/founditems] [/search] -Dan On Mon, 11 May 2009 16:00:50 -0700 (PDT) Rich Kwas wrote: >=20 > Is it possible to search 2 or more databases? >=20 > NOT a nested search.....=20 >=20 > Something like=20 > search database one, show it's results if any > search database two show its results if any etc. >=20 > the same thing would be searched for in these multiple databases >=20 > all done from one search form.... >=20 >=20 >=20 > My reason for the question: >=20 > I have a 4 year old community blogging type site where all the blog ent= ries are in "one"=20 >database. It's currently 30megs in size.... >=20 > I'm pondering how to simply things for an upcoming update and keeping s= tuff from 4 years ago=20 >with yesterdays entries seems overkill. I can't say for sure if anyone e= ven cares about blogs=20 >entries from 4 years ago LOL. BUT I'd want to be able to have them searc= h the entire spectrum of=20 >entries if they want, which makes me wonder if somehow having the entrie= s stored in a "yearly"=20 >database might be better.... >=20 >=20 > I suspect just keep the entries in one database is gonna be the best wa= y to continue. >=20 >=20 >=20 > =20 > --------------------------------------------------------- > 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/ "Dan Strong"

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:

Deleting Orders (1997) [ShowIf] and empty fields (1997) PCS Frames (1997) Text Variabels Not Passed To Include (2002) [OT] Discussion forum, last visit, Cookie, ... (2003) [WebDNA] Upgrade 4.5.1 to 6.0a (2009) Upgrade to wsV (2004) Emailer (WebCat2) (1997) Append problem w/" (1999) Quitting WebMerchant ? (1997) Error handling for accountNum (1997) Database Upload (2000) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Is there an alternative to emailer? (1999) Include (1998) Variables containing ! breaking HIDEIF's (1999) [include file=filename.inc&strip=t] (2002) Robust WebDNA Job Manager / Accountant (2006) WebCat & WebTen (1997) Banner DNA (1997)