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

ID: Q190743

The information in this article applies to:

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

SYMPTOMS

When trying to filter records based on a Boolean field on Active Server Pages (ASP) pages generated by the Dataform Wizard, the following error occurs when "Neither" is chosen for 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 "Neither" is chosen.

RESOLUTION

Change the code in the [...Form.asp] found on approximately line 248 from the following:


   If strFormMode = "Filter" Then
      Response.Write "<INPUT TYPE=Radio NAME=" & QuotedString(strFieldName)
      & " CHECKED>Neither"    ' Change this line '248
   End If

To the following:


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

STATUS

This behavior is by design.

Additional query words:

Keywords : kberrmsg kbADO kbADO150 kbASP kbASP400 kbASPObj kbDatabase kbVisID100 kbGrpASP kbiis400 kbiis500
Version : WINDOWS:1.0,1.5; winnt:
Platform : WINDOWS winnt
Issue type : kbprb