home *** CD-ROM | disk | FTP | other *** search
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
- <HTML>
- <HEAD>
- <!--META TAGS ARE RECOMMENDED FOR THE SEARCH ENGINE-->
- <META NAME="DESCRIPTION" Content="How It Works Page">
- <META NAME="KEYWORDS" CONTENT="help, code, source code, questions, explanation, index, content">
- <META NAME="GENERATOR" CONTENT="Microsoft Visual InterDev 1.0">
- <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso8859-1">
- <!--END META TAGS-->
-
- <TITLE>How the Content Indexing Pages Work</TITLE>
- </HEAD>
-
- <BODY BGCOLOR=#FFFFFF TOPMARGIN=0 LEFTMARGIN=0 ALINK=#23238E VLINK=#808080 LINK=#FFCC00>
- <BASEFONT FACE="VERDANA, ARIAL, HELVETICA" SIZE=2>
-
- <!--Change link color on mouseover
- Only if running Internet Explorer 4.0 or later -->
- <!--#include file=../libHighlight.inc-->
- <!--#include file=../libGlobalFuncs.inc-->
-
- <!--BEGIN TOP TABLE HOLDING GRAPHIC, NAVIGATIONAL LINK, AND MAIN CONTENT-->
- <TABLE WIDTH="100%" HEIGHT="100%" CELLPADDING=0 CELLSPACING=0 BGCOLOR="#000000" BORDER=0>
- <TR>
- <TD BGCOLOR="#000000" ALIGN=CENTER VALIGN=TOP WIDTH=170>
- <BR>
- <IMG SRC="../images/btslarge.jpg" HEIGHT=119 WIDTH=171 ALT="Behind the Scenes at Exploration Air" BORDER=0 ></A>
- <BR>
- <BR>
- <BR>
- <!--BACK BUTTON AND VARIABLE TO RETURN TO ORIGINATING PAGE-->
- <A HREF="<%=Request.ServerVariables("HTTP_REFERER")%>"><IMG SRC="../images/barrowy.gif" HEIGHT=8 WIDTH=8 ALT="Return to Previous Page" BORDER=0></A>
- <FONT SIZE=2 FACE="VERDANA, ARIAL, HELVETICA"><STRONG>
- <A HREF="<%=Request.ServerVariables("HTTP_REFERER")%>">
- B A C K </A>
- </STRONG></FONT>
- <BR>
- <BR>
-
- <!--JAVASCRIPT TO VIEW PAGE'S SOURCE CODE-->
- <A HREF="JavaScript:openWindow('../Search/Search.asp')">View Source</A>
- <BR>
- <BR>
-
- <!--JAVASCRIPT TO VIEW PAGE'S SOURCE CODE-->
- <A HREF="JavaScript:openWindow('../Search/AdvSearch.asp')">View Advanced Source</A>
- <BR>
- </TD>
-
- <TD BGCOLOR="#FFFFFF" BACKGROUND="../images/btsbg.gif" VALIGN=top>
- <BR CLEAR=ALL>
- <TABLE WIDTH="100%" CELLPADDING=10 CELLSPACING=0 BORDER=0>
- <TR>
- <TD VALIGN=top>
- <FONT FACE="VERDANA, ARIAL, HELVETICA" COLOR="#0000FF" SIZE=5>How the Content Indexing Pages Work</FONT>
- <HR>
- <FONT FACE="VERDANA, ARIAL, HELVETICA" SIZE="2">
- <H2>Functional Overview</H2>
- The set of Web pages in the Search directory allow the user to search for material using two
- types of search: Simple and Advanced.
- <P>
- <H3>Simple Search</H3>
- Simple search uses similar technology to that used in earlier versions of Microsoft Index Server. The query
- information is collected in Search.asp using a standard HTML form. Index Server
- supports a rich query language. If you installed the Index Server documentation, see the
- <A HREF="<%=GetServerName()%>/IISSamples/ISSamples/ixqlang.htm">Query Language</A> section.
- The query request is sent to Search.idq for processing. Search.idq works in conjunction with a file named Search.htx
- to produce the simple query output.
- <P>
- <H3>Advanced Search</H3>
- Index Server provides an alternative method of issuing queries on an indexed file system.
- Instead of using Index Server's standard forms, you can write SQL queries in applications that
- use ActiveX Data Objects (ADO). In your .asp files, use the SQL Extensions to form the query,
- ADO to retrieve the data, and a scripting language such as Microsoft Visual Basic, Scripting
- Edition (VBScript) to display the data.
- <P>
- The SQL used with Index Server consists of extensions to the subset of SQL-92 and SQL3 that
- specifies queries on relational database systems. This SQL includes extensions to the SELECT
- statement and its <STRONG>FROM</STRONG> and <STRONG>WHERE</STRONG> clauses.
- <P>
- <H4>Index Server Data, ADO, and OLE DB</H4>
- Because Index Server can function as an OLE DB provider, and with ADO you can consume OLE DB
- rowset data, you can take the results of an Index Server query and use them in a subsequent query
- against a different OLE DB provider (such as the ODBC Provider). For example, you can search for
- all the travel reports in a given directory and then submit a query against SQL Server to
- find the current travel budget of each trip report author.
- <P>
- The SQL extensions to Index Server do not support cross-data source queries; you need to issue
- separate queries against Index Server and (for example) the ODBC Provider to SQL Server.
- <P>
- <H4>How an Advanced Query Works</H4>
- The user enters data into an HTML form in the AdvSearch.asp page. Once this is
- entered, the page posts back to itself and the data is taken from the form.
- <P>
- Farther down the page a new query object is instantiated (<STRONG>ixsso.Query</STRONG>) and the query string is
- built dynamically by VBScript running on the server.
- <P>
- The query is then issued by calling the <STRONG>CreateRecordSet</STRONG> method on the query object.
- Finally, the results are displayed using normal ADO data fetching mechanisms
- (checking for the end of the resultset with the
- <STRONG>EOF</STRONG> property and using <STRONG>MoveNext</STRONG> property).
- <H2>Components Used</H2>
- The only component used is the Index Server component <STRONG>ixsso.Query</STRONG>.
- <P>
- </FONT>
- </TD>
- </TR>
- </TABLE>
- <!--END TOP TABLE HOLDING GRAPHIC, NAVIGATIONAL LINK, AND MAIN CONTENT-->
- <BR>
- <BR>
-
- <CENTER>
- <!--BEGIN LEGAL INFORMATION-->
- <TABLE CELLSPACING=0 CELLPADDING=0 BORDER=0>
- <TR>
- <TD>
- <FONT FACE="VERDANA, ARIAL, HELVETICA" SIZE="1"><A HREF="../legal.htm">©1997 Microsoft Corporation. All rights reserved. Terms of Use.</A></FONT>
- <P>
- </TD>
- </TR>
- </TABLE>
- </CENTER>
- <!--END LEGAL INFORMATION-->
- </TD>
- </TR>
- </TABLE>
-
- </BODY>
- </HTML>
-
- <SCRIPT LANGUAGE=JavaScript>
- function openWindow(SourceURL)
- {
- // Set some defaults
- width=450;
- height=450;
-
- url = "code.asp?Source=" + SourceURL;
- window.open(url,"Sample","resizable=yes,scrollbars=yes,width=" + width + ",height=" + height);
- }
- </SCRIPT>
-