Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-16 : 09:22:52
|
Patricia writes "Dear 4 Guys from Rolla,
Hi, my name is Patricia Wong and I am trying to build a page for my company's intranet. The company sells cameras and sometimes it loans its cameras to customers. I want to build a page that will 1) allow the user to search for any cameras still available for loan and 2) allow the user to pick out which camera it wants to loan out of those available and from there, update the databases, stating when he is going to take it out. Thus, there will be two information tables: one table will be updated constantly, with the user adding to it when the product will be taken out and where they will be using it, etc., therefore, creating a "history" of the borrowing of the camera. The other table will be static and hold the description of the cameras, and the sql statement is suppose to pick out the description of those cameras that are available to be loaned. Now, what I want to know is, how can I open two different tables at the same time?" |
|
|
|
|
|
Two Databases on the same .asp page