Search Multi Databases w/ASP

[RSG]

Hi,
I have a Intranet Site that we use ASP to search databases for paticular
info. I currently have several ASP search pages to search different tables in
different databases. I know I could combine the tables and do a search from
one database, but I want to keep the data separate. Is their any way to
search several databases from one asp page? The site was built using
FrontPage 2003 and is residing on a 2003 Server Standard Edition w/IIS 6.0.
Thanks

 

[Jens Peter Karlsen [FP-MVP]]

Yes, learn how to use JOIN in your SQL expression.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

 

[Stefan B Rusynko]

There is nothing in ASP preventing you from opening multiple DB tables & having multiple linked searches in a single asp page
- just move your search code to a single page (and connect it w/ say a series of If Then Else)




| Hi,
| I have a Intranet Site that we use ASP to search databases for paticular
| info. I currently have several ASP search pages to search different tables in
| different databases. I know I could combine the tables and do a search from
| one database, but I want to keep the data separate. Is their any way to
| search several databases from one asp page? The site was built using
| FrontPage 2003 and is residing on a 2003 Server Standard Edition w/IIS 6.0.
| Thanks
| --
| The Network Guy

 

[RSG]

O.K. Sounds simple enough. I built my pages with the wizards from FrontPage
03. Can I edit them or do I need to start over?

 

[Stefan B Rusynko]

Best done w/o the wizards
See http://www.asp101.com/samples/db_paged_search.asp

For the wizards maybe you can find something at http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp




| O.K. Sounds simple enough. I built my pages with the wizards from FrontPage
| 03. Can I edit them or do I need to start over?
| --
| The Network Guy
|
|
| "Stefan B Rusynko" wrote:
|
| > There is nothing in ASP preventing you from opening multiple DB tables & having multiple linked searches in a single asp page
| > - just move your search code to a single page (and connect it w/ say a series of If Then Else)
| >
| > --
| >
| > _____________________________________________
| > 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.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | Hi,
| > | I have a Intranet Site that we use ASP to search databases for paticular
| > | info. I currently have several ASP search pages to search different tables in
| > | different databases. I know I could combine the tables and do a search from
| > | one database, but I want to keep the data separate. Is their any way to
| > | search several databases from one asp page? The site was built using
| > | FrontPage 2003 and is residing on a 2003 Server Standard Edition w/IIS 6.0.
| > | Thanks
| > | --
| > | The Network Guy
| >
| >
| >