Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 190743 - Last Review: March 2, 2005 - Revision: 2.2
PRB: ADODB.Recordset Error '800a0bb9' When Using Boolean Filter
This article was previously published under Q190743
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 ....
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.
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
This behavior is by design.
APPLIES TO
- Microsoft Active Server Pages 4.0
- Microsoft Data Access Components 1.5
- Microsoft Visual InterDev 1.0 Standard Edition
| kbaspobj kbdatabase kberrmsg kbprb KB190743 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate