Microsoft KB Archive/265160

= FP2000: Query Criteria Doesn't Narrow Database Record Selection =

Article ID: 265160

Article Last Modified on 8/27/2002

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



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 &quot;OR&quot; is used in the query statement.



RESOLUTION
To resolve this issue, change the query's Boolean operator to &quot;AND.&quot;



MORE INFORMATION
When the Boolean operator in a query statement is &quot;OR,&quot; the conditions are satisfied when one or the other of the conditions is true. When the Boolean operator is &quot;AND,&quot; both conditions must be true for the record to be included in the query results.

Additional query words: ocsso front page

Keywords: kbprb KB265160

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.