Knowledge Base

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

Article ID: 190743

Article Last Modified on 3/2/2005

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 "<INPUT TYPE=Radio NAME=" & QuotedString(strFieldName)
      & " CHECKED>Neither"    ' Change this line '248
   End If

to:

   If strFormMode = "Filter" Then
      Response.Write "<INPUT TYPE=Radio NAME=" & QuotedString(strFieldName)
      & " value=" & QuotedString("") & " CHECKED>Neither"
   End If

STATUS

This behavior is by design.

Keywords: kberrmsg kbdatabase kbaspobj kbprb KB190743