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=20the 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]-DanOn 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:
I apologize ahead of time if I misunderstand, but here goes (totally goin=g shorthand to give you=20the 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]-DanOn 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)