PRB: ADODB.Recordset Error '800a0bb9' When Using Boolean FilterID: Q190743
|
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 ....
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.
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
If strFormMode = "Filter" Then
Response.Write "<INPUT TYPE=Radio NAME=" & QuotedString(strFieldName)
& " value=" & QuotedString("") & " CHECKED>Neither"
End If
This behavior is by design.
Additional query words:
Keywords : kberrmsg kbADO kbADO150 kbASP kbASP400 kbASPObj kbDatabase kbVisID100 kbGrpASP
Version : WINDOWS:1.0,1.5; winnt:
Platform : WINDOWS winnt
Issue type : kbprb
Last Reviewed: May 27, 1999