Sample SQL Based Search Form

Build your query below

SELECT the requested columns to build the Select-list from the list box below. Note: The * can only be used with a predefined view. To explicitly select properties, you must change extended_webinfo to a scope function, such as Scope().

SELECT
FROM
WHERE
ORDER BY

Completing the form

SELECT Clause

Choose one or more columns from the list. To select mutiple columns, use the CTRL key. To select a range of columns, use the SHIFT key. Note: You can only use * with a predefined view name in the FROM clause (See below.)

For example, you can choose Filename, DocAuthor, Size, VPath

The columns that appear in your Index Server query will be separated by commas as part of the query preparation process.

FROM Clause

The SCOPE() specification identifies the virtual roots or directories to perform the search. You can specify deep traveral (default) where all the subdirectories are searched, or shallow traversal where only the specified directory is searched. Alternatively, you can specify predefined views of FILEINFO, FILEINFO_ABSTRACT, EXTENDED_FILEINFO, WEBINFO, EXTENDED_WEBINFO in the FROM clause.

WHERE Clause

The WHERE clause specifies the filter condition of your search.

ORDER BY Clause

The optional ORDER BY clause is used to specify the column(s) which you wish the result set to be ordered on. You can leave this field blank.

Learn more about Internet Information Server! ©1997 Microsoft Corporation. All rights reserved.
Legal Notices. 		Download Internet Explorer!