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:

before after on (1998) Version 6 Problems (2004) Include a big block of text (1997) Pixo support? (1998) Sensations (1997) customizing the color of user's pages (1997) b12 cannot limit records returned and more. (1997) WCf2 and nested tags (1997) Reversed words (1997) Protect and Serve (1999) Shell Scripts (2003) WebCat2b13MacPlugIn - [include] (1997) For those of you not on the WebCatalog Beta... (1997) WebCat with WebTen (1998) Fwd: Problems with Webcatalog Plug-in (1997) Hideif on IP range (2004) Web Catalog 2 demo (1997) One more time (1997) [isfile] ? (1997) Running _every_ page through WebCat ? (1997)