FP2000: Query Criteria Doesn't Narrow Database Record Selection (265160)


The information in this article applies to:

  • Microsoft FrontPage 2000
This article was previously published under Q265160

SYMPTOMS

When you submit a query from an Active Server Page (ASP), you may receive results that both match and do not match the query's criteria.

CAUSE

This behavior can occur when the Boolean operator "OR" is used in the query statement.

RESOLUTION

To resolve this issue, change the query's Boolean operator to "AND."

MORE INFORMATION

When the Boolean operator in a query statement is "OR," the conditions are satisfied when one or the other of the conditions is true. When the Boolean operator is "AND," both conditions must be true for the record to be included in the query results.
Modification Type:MajorLast Reviewed:8/27/2002
Keywords:kbprb KB265160
©2002 Microsoft Corporation. All rights reserved.