database query help - 1 search 2 database results

D

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
 
S

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
|
|
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top