ASP 3.0 The Complete Reference
Chapter 20
Indexing Service (Outline and Notes)
Indexing
Service 3.0
Only files with
appropriate filter
Tied to NT Change
Journal
Using ADO and IXXSO
What you Need
IIS 5.0
also 4.0
Figure 1: Screen Shot of Catalog
Setup
A
Custom Search Page
Figure 2:Screen
Shot of Query Page
|
|
Query Page
|
|
1
2
3
4
5
6
7
8
9
10
|
|
Figure 3:
Screen Shot of Results Page
|
|
Results Page
|
|
1
2
3
4
5
6
7
8
9
10
|
|
Forming a Query
|
|
VBScript
|
|
1
2
3
4
5
6
7
8
9
10
|
|
Extracting Results
|
|
VBScript
|
|
1
2
3
4
5
6
7
8
9
10
|
|
Hit Highlighting
Webhits DLL - was exe in previous version
Figure 4: Screen shot of Hits
Page
|
|
VBScript
|
|
1
2
3
4
5
6
7
8
9
10
|
|
OLE DB Provider for Microsoft
Indexing Service
The Microsoft
OLE DB Provider for Microsoft Indexing Service provides programmatic read-only
access to file system and Web data indexed by Microsoft Indexing Service. ADO
applications can issue SQL queries to retrieve content and file property
information.
The provider is
free-threaded and unicode enabled.
What You Need
The Example
Figure 5: Indexing Service Via
ADO
|
|
VBScript
|
|
1
2
3
4
5
6
7
8
9
10
|
|
Creating a Comnnection
To connect to this
provider, set the Provider= argument to the ConnectionString property to:
"Provider=MSIDXS;Data
Source=myCatalog;Locale Identifier=nnnn;"
SQL Command Text
The Indexing
Service SQL query syntax consists of extensions to the SQL-92 SELECT statement
and its FROM and WHERE clauses. The results of the query are returned via OLE
DB rowsets, which can be consumed by ADO and manipulated as Recordset objects.
You can search for
exact words or phrases, or use wildcards to search for patterns or stems of
words. The search logic can be based on Boolean decisions, weighted terms, or
proximity to other words. You can also search by "free text," which
finds matches based on meaning, rather than exact words.
The specific
command dialect is fully documented in the Microsoft Indexing Service
Reference.
The provider does
not accept stored procedure calls or simple table names (for example, the
CommandType property will always be adCmdText).
Recordset Behavior
The following
tables list the features available with a Recordset object opened with this
provider. Only the Static cursor type (adOpenStatic) is available.
For more detailed
information about Recordset behavior for your provider configuration, run the
Supports method and enumerate the Properties collection of the Recordset to
determine whether provider-specific dynamic properties are present.
Availability of
standard ADO Recordset properties:
Office 2000 Web Components
Already Discussed
Pivot Table
Other Tools
Spreadsheet
Figure 6: Screen Shot
Chart
Figure 7:Screen Shot
Access Data Source
Figure 8: Screen Shot