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

The information in this article applies to:

Microsoft Active Server Pages
Microsoft Data Access Components 1.5
Microsoft Visual InterDev 1.0

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.

Modification Type:	Minor	Last Reviewed:	3/2/2005
Keywords:	kbASPObj kbDatabase kberrmsg kbprb KB190743