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> [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:
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> [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)