kwilliams
11-18-2003, 03:22 PM
MS ARTICLE: http://www.microsoft.com/ntserver/techresources/webserv/IndexServer.asp#sql
According to the article, I believe what happens is the following:
1) I'll create a template ASP page to be populated with DB data
2) SQL Server will create a web page for each record using the ASP page
3) We create an INSERT trigger that inserts a Web page whenever a record is inserted into the table.
4) We create an UPDATE trigger that updates a Web page whenever a record is updated from the table.
5) We create a DELETE trigger that deletes a Web page whenever a record is deleted from the table.
What I'm confused about is that I know that we can use Index Server on the site pretty well (w/IFilter). And I know that I can create a page that can do a full-index search on the database into a dynamic web page according to the primary key. I just don't understand why we can't somehow tie these two processes together without having to store web pages for each record in a database. I haven't found a way to do them together yet, but I'm still looking. Any suggestions??
KWilliams
According to the article, I believe what happens is the following:
1) I'll create a template ASP page to be populated with DB data
2) SQL Server will create a web page for each record using the ASP page
3) We create an INSERT trigger that inserts a Web page whenever a record is inserted into the table.
4) We create an UPDATE trigger that updates a Web page whenever a record is updated from the table.
5) We create a DELETE trigger that deletes a Web page whenever a record is deleted from the table.
What I'm confused about is that I know that we can use Index Server on the site pretty well (w/IFilter). And I know that I can create a page that can do a full-index search on the database into a dynamic web page according to the primary key. I just don't understand why we can't somehow tie these two processes together without having to store web pages for each record in a database. I haven't found a way to do them together yet, but I'm still looking. Any suggestions??
KWilliams