Sample SQL Based Search Form

Building an SQL Query

SELECT Clause
Select the requested columns to build the Select-list from the list box. Choose one or more columns from the list. To select multiple columns, use the CTRL key. To select a range of columns, use the SHIFT key. 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.
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 Clause
The SCOPE() specification identifies the virtual roots or directories to perform the search. You can specify deep traversal (default) where all the subdirectories are searched, or shallow traversal where only the specified directory is searched.
Note: You can specify predefined views of FILEINFO, FILEINFO_ABSTRACT, EXTENDED_FILEINFO, WEBINFO, EXTENDED_WEBINFO in the FROM clause. FROM

WHERE Clause
The WHERE clause specifies the filter condition of your search. WHERE

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. ORDER BY
SQL Syntax Tips


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