Expand News
IS Administration
Expand MMC
Expand Com Objects
Expand IDA/IDQ
IS Programming
Expand IS Programming
IS TroubleShooting
Expand Indexing
Expand Querying
IS Optimizing
Expand Querying
Expand Indexing
IS Links
Expand MSDN
Expand TechNet
Expand Other MS
Expand Other Links
iFilters
Expand iFilters
SQL 2000 FTS
Expand Loading Data
Expand Indexing
Expand Querying
Contains
Freetext
ContainsTable/FreetextTable
ASP
ISAPI
.Net
SQLXML
Thesaurus
Languages
Trouble Shooting
Hit Highlighting
Blobs
Dealing with Noise words
Expand SQL FTS Links
SQL 2005 FTS
Expand What's New

SQL FTS ASP Sample Pages

Here are four sample pages.

  • The first example is a plain vanilla asp page that incorporates paging. The query is issued through a stored procedure using the command object of ADO. Download files here.

  • The second example uses GetRows. GetRows is a method in ADO that will stuff the recordset into an array and allow you to iterate your results set. This method offers better performance. Download files here.

  • The third method demonstrates hit highlighting. This method uses the hit highlighting features of Indexing Services. A copy of the contents of your main text/char field must be stored in the file system. Download files here.

  • The fourth method uses aspx. Download files here.

     

     

     

  •  

    designed by :: smilla group