home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 1999 September
/
CHIPCD_9_99.iso
/
software
/
uaktualnienia
/
OptionPackPL
/
iis4_07.cab
/
HIWIndexServer.asp
< prev
next >
Wrap
Text File
|
1998-04-27
|
6KB
|
143 lines
<!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>