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 - 2002-01-31 : 09:48:54
|
| Stewart writes "I have a databse with multiple tables. First id like to connect to different tables within that specific database. Also id like to know how i can update and change the values of a lookup field in the database from ASP on the web. If its possible i hope u can help Thanks.Sincerely,Stewart" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-01-31 : 09:57:30
|
| Technically speaking, you connect to a database server, and optionally connect to a specific database on that server. Once you've got that connection, you can access any table, view, stored procedure, etc. that exists in that database (as long as your login has permissions for those objects).It's hard to say how to go about the update you want to do without more information. Are you using Access, SQL Server, or another database program? How does the end user modify the lookup values? What does the update modify? Does the modification happen only on the database side, or does it need to appear on the web page as well?You can also try browsing some ASP sites, you'll probably find a solution on one of them:www.4guysfromrolla.comwww.asp101.comwww.learnasp.comwww.aspalliance.comwww.15seconds.com |
 |
|
|
|
|
|
Connecting to multiple tables