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 - 2003-09-30 : 08:06:53
|
| dan writes "Hi, and thanks in advance for your help. My environment, Windows Server 2000 all service packs applied, SQL Server2000 SP3a, IIS, all software resides on a single machine. I need to have an SQL trigger pass a value to an Active Server Page. I cannot seem to find a mechanism for passing the value from the trigger to ASP. " |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-30 : 08:09:09
|
| Good. You shouldn't use this kind of technique as it is a great way to lock up your SQL Server. Never try to access an external app from a trigger if that external app cannot close itself.Instead, take the data you need from inside the trigger and have the trigger insert it into another table in the database. Then write your ASP code to access that table instead, and optionally clear the data from it when it's complete. |
 |
|
|
|
|
|
sending data from an SQL trigger to an ASP page.