Access a DB through the webgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
Hello Eric, At the first thank you for your collaboration. I want to access a DB through the web, to do that i created a interface in the web but the problem is that i don't know if it is possible to restore the user's variables and execute the result query in SQLServer Web Assistant. I explain: I have for example a table 'Movie' with Name_actor, Name_movie. I want to create a interface which is able to do that: The user can do some search in the database like (e.g the user want to know all movies which the name_actor=De Niro) that the reason why i want to restore the user variable (e.g De Niro).
-- Anonymous, December 10, 1999
The SQL Server Books Online states, in the article titled, "Using the Web Assistant Wizard" that "With the Web Assistant Wizard, you can generate an HTML file one time or as a regularly scheduled SQL Server task."
Based on this documentation, it is clear that Web Assistant can not do what you have asked.
For what you are asking, I suggest that you use Allaire's ColdFusion product. This is also possible using Active Server Pages.
Hope this helps,
-- Anonymous, December 12, 1999