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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Using Web Assistant rather than ASP

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-18 : 09:21:51
David writes "I'm developing a news-delivery application for my company's intranet, and at present it is purely ASP based, querying a back-end SQL 7 database when given a specific story id number. However, since the stories don't change once they've been posted, I wanted to write a trigger that fires off a Web Assistant task to write out the newly-posted story to an HTML file using the existing sp_runwebtask.

As far as I can see, though, there is no way of passing parameters to a pre-defined Web Assistant task (such as the contents of the UDPATED table from the trigger).

Can anyone help?"
   

- Advertisement -