database query help - 1 search 2 database results

[Doug]

Hello. I am trying to create a query in my FrontPage web site that shows the
results in 2 databases. Does anyone know how to do this?

I would like to have only one search form. I have two separate databases.
Can I have the results of one database appear on the same page as the
results of the other database having the visitor search once.

Example Page:


SEARCH FORM

RESULTS DATABASE 1

_________________________

RESULTS DATABASE 2

 

[Ronx]

Yes. Bur requires hand coding the search page form handler.

 

[Stefan B Rusynko]

Yes
- requires hand coding your server side script to run 2 searches and return the results separately
You'll find a simple search at http://www.asp101.com/samples/db_search.asp
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hello. I am trying to create a query in my FrontPage web site that shows the
| results in 2 databases. Does anyone know how to do this?
|
| I would like to have only one search form. I have two separate databases.
| Can I have the results of one database appear on the same page as the
| results of the other database having the visitor search once.
|
| Example Page:
|
|
| SEARCH FORM
|
| RESULTS DATABASE 1
|
| _________________________
|
| RESULTS DATABASE 2
|
|

 

[MD Websunlimited]

Hi Doug,

First, define "database" are these separate .mdb files or a single .mdb file with using different tables? If the latter you may just
a join type SQL statement to use columns from both tables.