You receive a "Database Results Error" error message when you use a database Contains query in FrontPage

When you use a Contains query to query for data in a Database Results Region, an error message similar to one of the following appears:

If you are using a Microsoft Access databaseIf you are using a Microsoft SQL Server database

The criteria you used in the query contains an apostrophe ('). The database engine interprets the apostrophe to mean the end of the search text.

To work around this problem, use the Dynamic HTML sample in the following Microsoft Knowledge Base artice:

The FrontPage database library routines for reserved characters, such as an apostrophe, do not parse queries that use Contains criteria but do parse queries that use Like criteria. Queries using contains criteria are not parsed by the FrontPage database library routines for reserved characters, such as an apostrophe, although queries using Like criteria are. Queries using Contains criteria are wrapped in wildcard characters. This allows searching for the specified criteria anywhere within the database field. Queries using Like criteria are parsed for reserved characters. These characters are converted to escape sequences, and then compared exactly with the database.

A query using Like criteria can function as a Contains query. To achieve this functionality, simply enclose the search text inside percent signs (%), like this:

For additional information about additional errors that may appear when you work with the Database Results Region, click the article numbers below to view the articles in the Microsoft Knowledge Base: