Microsoft KB Archive/190743

= PRB: ADODB.Recordset Error '800a0bb9' When Using Boolean Filter =

Article ID: 190743

Article Last Modified on 3/2/2005

-

APPLIES TO


 * Microsoft Active Server Pages 4.0
 * Microsoft Data Access Components 1.5
 * Microsoft Visual InterDev 1.0 Standard Edition

-



This article was previously published under Q190743



SYMPTOMS
When you try to filter records based on a Boolean field on Active Server Pages (ASP) pages that the Dataform Wizard generates, you receive the following error message when you click Neither in this column:

ADODB.Recordset error '800a0bb9'

The application is using arguments that are of the wrong type, are out

of acceptable range, or are in conflict with one another.

....., line ....



CAUSE
This error occurs because the logical operator within the ASP page that the Dataform Wizard generates is not assigned to Null when you choose Neither.



RESOLUTION
Change the code in the [...Form.asp], which is located at approximately line 248, from If strFormMode = "Filter" Then Response.Write "Neither"   ' Change this line '248 End If to: If strFormMode = "Filter" Then Response.Write "Neither" End If



STATUS
This behavior is by design.

Keywords: kberrmsg kbdatabase kbaspobj kbprb KB190743

-

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

© Microsoft Corporation. All rights reserved.