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:

Help name our technology! (1997) [date format] w/in sendmail (1997) WebCat b13 CGI -shownext- (1997) [ShowNext] feature in 2.0 (1997) Javascript Stored in a Database (2003) Sort of a Dilema! (1998) Price written to db as scientific notation??? (1999) Template not found error messages (1997) [WebDNA] Admin group limits (2010) BCC Limits (2002) More to Expire (1998) Cold Fusion Warm and Fuzzy? (1999) Requiring that certain fields be completed (1997) looking for some paid WebCatalog help (2000) Hyperlink in email (2002) OK, here goes... (1997) Progress !! WAS: Trouble with formula.db (1997) WebCommerce: Folder organization ? (1997) PCS Frames (1997) [WebDNA] Manual Sever Upgrade (2015)