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

View products that this article applies to.

This article was previously published under Q190743

Expand all | Collapse all

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 ....

Back to the top

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.

Back to the top

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

Back to the top