Re: [WebDNA] Search 2 databases ???

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102544
interpreted = N
texte = Interesting, I'll give it a try.=0A=0AAll my old sites were using vers 4.51= until recently, and now I'm trying to implement some more functionality in= to them, and tables would certainly be in that scenario.=0A=0AThanks.=0A=0A= =0A=0A=0A=0A--- On Mon, 5/11/09, Dan Strong wrote:= =0A=0A> From: Dan Strong =0A> Subject: Re: [WebDNA] S= earch 2 databases ???=0A> To: talk@webdna.us=0A> Date: Monday, May 11, 2009= , 6:09 PM=0A> I apologize ahead of time if I=0A> misunderstand, but here go= es (totally going shorthand to=0A> give you the gist):=0A> =0A>
=0A> = =0A>
=0A> =0A> [table=0A> name=3DtheS= earchResultsTable&fields=3DsomeID,searchTerm]=0A> [/table]=0A> =0A> [search= database #1..]=0A> [founditems]=0A> [append table=3DtheSearchResultsTable.= .][/append]=0A> [/founditems]=0A> [/search]=0A> =0A> [search database #2..]= =0A> [founditems]=0A> [append table=3DtheSearchResultsTable..][/append]=0A>= [/founditems]=0A> [/search]=0A> =0A> etc.=0A> =0A> [search table=3DtheSear= chResultsTable..]=0A> [founditems]=0A> ...show your results here ...=0A> [/= founditems]=0A> [/search]=0A> =0A> -Dan=0A> =0A> On Mon, 11 May 2009 16:00:= 50 -0700 (PDT)=0A> Rich Kwas =0A> wrote:=0A> > = =0A> > Is it possible to search 2 or more databases?=0A> > =0A> > NOT a nes= ted search..... =0A> > Something like search database one, show it's result= s=0A> if any=0A> > search database two show its results if any etc.=0A> > = =0A> > the same thing would be searched for in these multiple=0A> databases= =0A> > =0A> > all done from one search form....=0A> > =0A> > =0A> > =0A> > = My reason for the question:=0A> > =0A> > I have a 4 year old community blog= ging type site where=0A> all the blog entries are in "one" database. It's c= urrently=0A> 30megs in size....=0A> > =0A> > I'm pondering how to simply th= ings for an upcoming=0A> update and keeping stuff from 4 years ago with yes= terdays=0A> entries seems overkill. I can't say for sure if anyone even=0A>= cares about blogs entries from 4 years ago LOL. BUT I'd want=0A> to be abl= e to have them search the entire spectrum of=0A> entries if they want, whic= h makes me wonder if somehow=0A> having the entries stored in a "yearly" da= tabase might be=0A> better....=0A> > =0A> > =0A> > I suspect just keep the = entries in one database is=0A> gonna be the best way to continue.=0A> > =0A= > > =0A> > =0A> >=A0 =A0 =A0=0A> ------------------------------------------= ---------------=0A> > This message is sent to you because you are subscribe= d=0A> to=0A> > the mailing list .=0A> > To unsubscribe, E-m= ail to: =0A> > archives: http://mail.webdna.us/list/t= alk@webdna.us=0A> > old archives: http://dev.webdna.us/TalkListArchive/=0A>= =0A> ---------------------------------------------------------=0A> This me= ssage is sent to you because you are subscribed to=0A> the mailing list .=0A> To unsubscribe, E-mail to: =0A> ar= chives: http://mail.webdna.us/list/talk@webdna.us=0A> old archives: http://= dev.webdna.us/TalkListArchive/=0A> =0A=0A=0A 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)
Interesting, I'll give it a try.=0A=0AAll my old sites were using vers 4.51= until recently, and now I'm trying to implement some more functionality in= to them, and tables would certainly be in that scenario.=0A=0AThanks.=0A=0A= =0A=0A=0A=0A--- On Mon, 5/11/09, Dan Strong wrote:= =0A=0A> From: Dan Strong =0A> Subject: Re: [WebDNA] S= earch 2 databases ???=0A> To: talk@webdna.us=0A> Date: Monday, May 11, 2009= , 6:09 PM=0A> I apologize ahead of time if I=0A> misunderstand, but here go= es (totally going shorthand to=0A> give you the gist):=0A> =0A>
=0A> = =0A>
=0A> =0A> [table=0A> name=3DtheS= earchResultsTable&fields=3DsomeID,searchTerm]=0A> [/table]=0A> =0A> [search= database #1..]=0A> [founditems]=0A> [append table=3DtheSearchResultsTable.= .][/append]=0A> [/founditems]=0A> [/search]=0A> =0A> [search database #2..]= =0A> [founditems]=0A> [append table=3DtheSearchResultsTable..][/append]=0A>= [/founditems]=0A> [/search]=0A> =0A> etc.=0A> =0A> [search table=3DtheSear= chResultsTable..]=0A> [founditems]=0A> ...show your results here ...=0A> [/= founditems]=0A> [/search]=0A> =0A> -Dan=0A> =0A> On Mon, 11 May 2009 16:00:= 50 -0700 (PDT)=0A> Rich Kwas =0A> wrote:=0A> > = =0A> > Is it possible to search 2 or more databases?=0A> > =0A> > NOT a nes= ted search..... =0A> > Something like search database one, show it's result= s=0A> if any=0A> > search database two show its results if any etc.=0A> > = =0A> > the same thing would be searched for in these multiple=0A> databases= =0A> > =0A> > all done from one search form....=0A> > =0A> > =0A> > =0A> > = My reason for the question:=0A> > =0A> > I have a 4 year old community blog= ging type site where=0A> all the blog entries are in "one" database. It's c= urrently=0A> 30megs in size....=0A> > =0A> > I'm pondering how to simply th= ings for an upcoming=0A> update and keeping stuff from 4 years ago with yes= terdays=0A> entries seems overkill. I can't say for sure if anyone even=0A>= cares about blogs entries from 4 years ago LOL. BUT I'd want=0A> to be abl= e to have them search the entire spectrum of=0A> entries if they want, whic= h makes me wonder if somehow=0A> having the entries stored in a "yearly" da= tabase might be=0A> better....=0A> > =0A> > =0A> > I suspect just keep the = entries in one database is=0A> gonna be the best way to continue.=0A> > =0A= > > =0A> > =0A> >=A0 =A0 =A0=0A> ------------------------------------------= ---------------=0A> > This message is sent to you because you are subscribe= d=0A> to=0A> > the mailing list .=0A> > To unsubscribe, E-m= ail to: =0A> > archives: http://mail.webdna.us/list/t= alk@webdna.us=0A> > old archives: http://dev.webdna.us/TalkListArchive/=0A>= =0A> ---------------------------------------------------------=0A> This me= ssage is sent to you because you are subscribed to=0A> the mailing list .=0A> To unsubscribe, E-mail to: =0A> ar= chives: http://mail.webdna.us/list/talk@webdna.us=0A> old archives: http://= dev.webdna.us/TalkListArchive/=0A> =0A=0A=0A 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:

customizing the color of user's pages (1997) Re:no [search] with NT (1997) WebCat2.0 acgi vs plugin (1997) Authenticate (1997) off topic - dna snipets (1997) upgrading (1997) Adding up weights (1998) Single Link browsing (1997) RE: [WebDNA] Installing WebDNA on Windows 7 (2009) WCS Newbie question (1997) More on the email templates (1997) [Repost] Triggers, again SM??? (2000) Major bug report on rootbeer (1997) Dummy Credit Card Number for debug? (1997) WebCat cannot handle compatible search parameters? (1997) WebCatalog for guestbook ? (1997) [BULK] [WebDNA] Wishlist: ignore whitespace in database changes (2016) Fuzzy on [url] context (1998) Max Record length (1997) Emailer setup (1997)