Re: [WebDNA] Search 2 databases ???
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102542
interpreted = N
texte = Put the results of the 2 searches into a table and then you can search the table.RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 12/05/2009, at 9:00 AM, Rich Kwas wrote:>> Is it possible to search 2 or more databases?>> NOT a nested search.....>> Something like> search database one, show it's results if any> search database two show its results if any etc.>> the same thing would be searched for in these multiple databases>> all done from one search form....>>>> My reason for the question:>> I have a 4 year old community blogging type site where all the blog > entries are in "one" database. It's currently 30megs in size....>> I'm pondering how to simply things for an upcoming update and > keeping stuff from 4 years ago with yesterdays entries seems > overkill. I can't say for sure if anyone even cares about blogs > entries from 4 years ago LOL. BUT I'd want to be able to have them > search the entire spectrum of entries if they want, which makes me > wonder if somehow having the entries stored in a "yearly" database > might be better....>>> I suspect just keep the entries in one database is gonna be the best > way to continue.>>>>> ---------------------------------------------------------> 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:
Put the results of the 2 searches into a table and then you can search the table.RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 12/05/2009, at 9:00 AM, Rich Kwas wrote:>> Is it possible to search 2 or more databases?>> NOT a nested search.....>> Something like> search database one, show it's results if any> search database two show its results if any etc.>> the same thing would be searched for in these multiple databases>> all done from one search form....>>>> My reason for the question:>> I have a 4 year old community blogging type site where all the blog > entries are in "one" database. It's currently 30megs in size....>> I'm pondering how to simply things for an upcoming update and > keeping stuff from 4 years ago with yesterdays entries seems > overkill. I can't say for sure if anyone even cares about blogs > entries from 4 years ago LOL. BUT I'd want to be able to have them > search the entire spectrum of entries if they want, which makes me > wonder if somehow having the entries stored in a "yearly" database > might be better....>>> I suspect just keep the entries in one database is gonna be the best > way to continue.>>>>> ---------------------------------------------------------> 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/
Stuart Tremain
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:
Sendmail doesn't (was Queertrons?) (1997)
Does anyone have a solution to make carts smaller? (1998)
Can this be done? (1997)
method of payment (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Byte Order Mark - removing via webcat? (2006)
Setting up the server (1997)
Problem with updating 2.1b7 -> 2.1.1 (1998)
Add a field to the error log? (1997)
[protect] on NT? (1997)
StoreBuilder help/question... (2000)
corrupted images (2002)
IBM DB2 (2000)
WebCat (or other) Indexing (1999)
Erotic Sites (1997)
Mozilla/4. and Browser Info.txt (1997)
Some Questions (1997)
Add to cart issue (2007)
Database location (2002)
SendMail - Idea (2000)