Re: Searching Multiple DBs

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11941
interpreted = N
texte = >Blokes and Blokettes... > >I was trying to experiment with a fairly large database (160,000 records - >12 fields) that was a bit unmanageable as a single file (around 16 megs on >disk), and so I thought I'd be clever and split it up into 12 different >databases of roughly 15,000 records a piece. > >I was thinking I could perform a search treating all of these files as >ONE, by doing something like: > >
>value=db1.TXT,db2.TXT,db3.TXT,db4.TXT,db5.TXT> > >Name: >Company: > > >
> >Which doesn't work, since it appears that it looks as the list of >databases I gave it as one REALLY LONG filename. > >I've since re-joined the databases into ONE file and searching works fine >(aside from needing TONS of RAM), but I could see searching multiple >databases having the same form as being a rather useful function - so, is >it possible or WILL it be possible in the future?It's possible now, all you have to do is put 12 search contexts on your results page - one for each database. And yes, you only need one form to do all 12 searches. Instead of making the form a search form, make it a 'variable collection' form. Collect all the user's inputs on the form as variables, then use those variables in all 12 of your search contexts on the next page ... :)Sincerely, Ken Grome WebDNA Solutions Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching multiple dbs (Kenneth Grome 1998)
  2. Searching multiple dbs (Robert Ruth 1998)
  3. Re: Searching Multiple DBs (Kenneth Grome 1997)
  4. Searching Multiple DBs (Dan Keldsen 1997)
>Blokes and Blokettes... > >I was trying to experiment with a fairly large database (160,000 records - >12 fields) that was a bit unmanageable as a single file (around 16 megs on >disk), and so I thought I'd be clever and split it up into 12 different >databases of roughly 15,000 records a piece. > >I was thinking I could perform a search treating all of these files as >ONE, by doing something like: > >
>value=db1.TXT,db2.TXT,db3.TXT,db4.TXT,db5.TXT> >[cart]> >Name: >Company: > > >
> >Which doesn't work, since it appears that it looks as the list of >databases I gave it as one REALLY LONG filename. > >I've since re-joined the databases into ONE file and searching works fine >(aside from needing TONS of RAM), but I could see searching multiple >databases having the same form as being a rather useful function - so, is >it possible or WILL it be possible in the future?It's possible now, all you have to do is put 12 search contexts on your results page - one for each database. And yes, you only need one form to do all 12 searches. Instead of making the form a search form, make it a 'variable collection' form. Collect all the user's inputs on the form as variables, then use those variables in all 12 of your search contexts on the next page ... :)Sincerely, Ken Grome WebDNA Solutions Kenneth Grome

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:

OT: How to find out who owns an IP address (2001) What do the &x=5&y=8 mean? (2002) Carts & cookies (1999) no global [username] or [password] displayed ... (1997) WebDNA vs PHP (2003) [OT] mozilla / Seamonkey (2007) Verifying SSL on Page (2002) UNC path support in WebDNA 5.0 (2003) Time math (2002) Carts & Refering URLs (1997) Using Plug-In while running 1.6.1 (1997) Exclamation point (1997) WebCatalog can't find database (1997) More on the email templates (1997) Quit revisited (1997) WebCat2b15MacPlugin - showing [math] (1997) RAM variables (1997) RE: Error -108 (1997) NT or Mac (1998) Help formatting search results w/ table (1997)