ASPAlliance ASP Kitchen  
Search: Go  

ASP Kitchen: ASPWatch.com articles: ASP and Site Server Search

Using the Site Server Search Facility to Search Custom Meta Tags

Introduction

An interesting feature of the Site Server 3.0 Search facility is the ability to search custom Meta Tags. A common use of this facility is to enable users of a web site to narrow down their searches to a particular part of a website.

Restricting searches

In a well organised site, you could restrict searches by only allowing searches of specific file paths. For example, the following will restrict searches to the financial section of the www.foo.com website:

Util.AddScopeToQuery Q, "http://www.foo.com/financial/", "deep"

However, if your content is distributed in many different folders (or even on different servers) then a file path restriction is not appropriate.

A possible alternative is to tag certain pages with specific Meta Tags. The Tag Tool that is supplied with Site Server allows this to be done for entire websites at a time. Obviously, if you use Perl or some other type of scripting to generate static web pages from databases then adding Meta Tags is very straightforward.

Searching custom Meta Tags

The first stage is to add the custom Meta Tags to your web page. So if you want to tag the Customer Support and Financial Services pages respectively, add the following HTML to each:

<META NAME="Department" CONTENT="Customer Support">

<META NAME="Department" CONTENT="Financial Services">

Having done this, you will have to rebuild the Search Catalog for that website.

The ASP code that will create a basic search results page that will allow searching of these pages is below. Be sure to change the value of the Q.Catalog to the name of your Search Catalog!

<%
set Util = Server.CreateObject("MSSearch.Util")
set Q = Server.CreateObject("MSSearch.Query")

Q.Catalog = "catalog_name"
Q.SortBy = "rank[d]"
Q.MaxRecords = 300
Q.Columns = "DocTitle, DocAddress, size, write, rank"
Q.Query = "@Meta_Department Financial Services"

Set RS = Q.CreateRecordSet("sequential")

Do while not RS.EOF
Response.Write "<A HREF=" & Chr(34) & RS("DocAddress") & Chr(34) & ">" & RS("DocTitle") & "</A><BR>"
RS.MoveNext
Loop

Set Util = nothing
Set Q = nothing
%>

Note that the search query specifies that the Department Meta Tag should be searched for instances of “Financial Services”. If you want to restrict searching to the Customer Support pages instead of the Financial Services pages, then modify the code appropriately:

Q.Query = "@Meta_Department Customer Support"

You could also search other custom Meta Tags in a similar way by adding the Meta_ prefix to them. So if an online store wanted to search the “ProductArea” Meta Tag, then you could use a Query such as:

Q.Query = "@Meta_ProductArea Toys"

Retrieving contents of Meta Tags

If you want to retrieve the contents of Meta Tags and display them with the search results, then you need to use the following procedure, otherwise you may see an error similar to this:

ADODB.Fields error '800a0cc1'
ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application.
/finance/search/default.asp, line 164

First, add Meta_Department to the Q.Columns line of the ASP code:

Q.Columns = "DocTitle, DocAddress, size, write, rank, Meta_Department"

Once you have done this, in the Site Server Administrator Microsoft Management Console (MMC), go to Console Root > Search > your_machine_name > Catalog Build Server > your_catalog_name > Schema. In the Catalog Schema part of the MMC, click on the Add button. When the Add Schema Column part of the MMC appears, add the following:

  • Property name = Meta_Department
  • Property set = click on Standard property set, and change drop-down list to HTML Meta
  • Property ID = department
  • Type = change the drop-down list to String
  • Index = Yes
  • Retrieve = Yes

When you have clicked on the Submit button, you are given the choice of changing the Master Schema (this changes all the Catalogs on that Search server) or creating a Custom Schema (this only changes the current Catalog). Having changed the Schema, you will then have to rebuild the Search Catalog.

If you subsequently modify the ASP code to the following, each search result will then display the contents of the Department Meta Tag:

Response.Write "<A HREF=" & Chr(34) & RS("DocAddress") & Chr(34) & ">" & RS("DocTitle") & "</A> (" & RS("Meta_Department")& ") <BR>"

Further reading

This is a brief introduction to the use of custom Meta Tags with Site Server. On well managed sites the use of such searches could make it a lot easier for your web site users to quickly find the content they are looking for.

  • Index Server Companion. The Index Server Companion allows Index Server to index content from remote websites and ODBC databases. A much cheaper alternative to Site Server 3.0 Search!
  • It is also possible to use Index Server to search custom Meta Tags. Further information is available here.

Useful Development Tools

ASP Documentation Tool™
Automatically creates technical documentation for ASP 2.0 and 3.0 web applications written in VBScript and JScript. Documentation for Microsoft Access, SQL Server 7/2000 databases and Visual Basic 6.0 components associated with the web application can also be incorporated into the reports. Documentation is created in HTML, HTML Help and plain text formats.
   View Sample Output (HTML Help format) View Sample Output (HTML Help format).
   View Sample Output (HTML Format) View Sample Output (HTML Format).
   Download Trial Version Download Trial Version (5.2Mb ZIP file).

.NET Documentation Tool
Automatically creates technical documentation for .NET Framework applications written in C# or VB.NET (including ASP.NET). Documentation for SQL Server 7/2000/2005 databases and C#/VB.NET components associated with the web application can also be incorporated into the reports. Documentation is created in HTML, HTML Help and plain text formats. Additional support for ASP.NET web applications. A useful alternative to NDoc!
   View Sample Output (HTML Help format) View Sample Output (HTML Help format).
   View Sample Output (HTML Format) View Sample Output (HTML Format).
   Download Trial Version Download Trial Version (3Mb ZIP file).

SQL Documentation Tool
The SQL Documentation Tool creates technical documentation for Microsoft SQL Server 7.0, 2000 and 2005 databases. Technical documentation is created in HTML and HTML Help formats. The HTML Help format documentation is fully searchable and cross referenced. The SQL Documentation Tool documents SQL Server Tables, Views, Stored Procedures, Triggers, Table Relationships, Jobs and DTS Packages.
   View Sample Output (HTML Help format) View Sample Output (HTML Help format).
   View Sample Output (HTML Format) View Sample Output (HTML Format).
   Download Trial Version Download Trial Version (10.3Mb ZIP file).

VB Documentation Tool
The VB Documentation Tool creates technical documentation for Microsoft Visual Basic 6.0 projects. Technical documentation is created in HTML and HTML Help formats. The HTML Help format documentation is fully searchable and cross referenced.
   View Sample Output (HTML Help format) View Sample Output (HTML Help format).
   View Sample Output (HTML Format) View Sample Output (HTML Format).
   Download Trial Version Download Trial Version (1Mb ZIP file).

The Website Utility
The Website Utility examines websites for errors and areas that need to be optimised for search engines by using a built in web crawling engine. Errors checked for include broken or moved hyperlinks, missing page titles and missing meta tags. It also generates HTML for use in creating website site maps (table of contents pages - like this one), and is able to create both client-side JavaScript search engines and server-side ASP search engines and ASP.NET search engines for a website.
   View Sample Output (HTML Format) View Sample Output (HTML Format).
   Download Trial Version Download Trial Version (3Mb ZIP file).

Text Workbench
Text Workbench is a file search and replacement utility for text files and Microsoft Office documents. Make rapid file replacements on multiple files and folders full of files. Advanced replacement options include regular expressions support. It even works on remote file systems via FTP. A Regular Expression Laboratory allows advanced pattern matching and replacement expressions to be built and tested. This great utility will make your everyday development tasks much easier!
   Download Trial Version of Text Workbench Download Trial Version (3Mb ZIP file; you have the option to either install directly from this link or save the file for later installation).

Indexing Service Companion
The Indexing Service Companion is a utility that extends the functionality of the Microsoft Windows Indexing Service so that it is able to index content from any remote website and also from ODBC compliant databases. As such it can be used as a low cost alternative to Sharepoint's Search Services.
   View Product Documentation View Product Documentation (119K ZIP file).
   Try Sample Search Facility Try Sample Search Facility.
   Download Trial Version Download Trial Version (1.7Mb ZIP file).

ASP Spell Check
ASPSpellCheck is the easy way to add spell checking capabilities to your ASP or ASP.NET websites, Intranets and web applications. The utility allows you to add spell checking capabilities to any HTML text field or rich content editing text box. It works with all common web browsers, and there are no components or databases to install on the server.
   Read a review of the ASP Spell Check server component Read ASPSpellCheck Review.
   View Examples of the ASPSpellCheck component for adding spell checking capabilities to ASP web applications View ASPSpellCheck Examples.
   Download Trial Version of ASPSpellCheck Download Trial Version (3Mb ZIP file; you have the option to either install directly from this link or save the file for later installation).

Author details

Brett Burridge has worked as a web developer since 1997 and has developed web applications for a range of corporations, start up busiensses and educational establishments.

Brett is presently employed as an Internet developer and technical writer through his own company, Winnersh Triangle Web Solutions Limited. The company produces a number of innovative products, including a range of software documentation tools, which include the ASP Documentation Tool™, the .NET Documentation Tool for VB.NET and C#, and the SQL Server Documentation Tool. Other products include The Website Utility, which functions as a website error checker, search engine optimizer and ASP/ASP.NET search engine builder application.

As well as the ASPAlliance, Brett has written articles for Ariadne.ac.uk, ASPToday, the software documentation portal www.softwaredocumentation.info, and has contributed recipes to the ASP.NET Developer's Cookbook.    links

Outside web development, Brett is interested in travelling (here are my travel logs from New York, Hong Kong and Tokyo), digital photography (here's my photo gallery), tropical fishkeeping and collecting contemporary works of art by artists such as Doug Hyde.

Contact Brett by emailing

Download a free ASP Documentation Tool now!!!

Article history

"Using the Site Server Search facility to search custom Meta Tags" originally published on ASPWatch.com on August 28 1999. Republished on ASPAlliance.com on 26 September 2001.

ASP Kitchen: ASPWatch.com articles: ASP and Site Server Search

Documentation tools to automate the documentation of SQL Server databases and ASP, C#, VB.NET and VB 6.0 application source code

Download a Free ASP Documentation Tool Now!

Google

Search Engine Builder - Build a search engine for your website!

© page content copyright Brett Burridge 1998 - 2008.