Article ID: 190743
Article Last Modified on 3/2/2005
APPLIES TO
- Microsoft Active Server Pages 4.0
- Microsoft Data Access Components 1.5
- Microsoft Visual InterDev 1.0 Standard Edition
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:
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.
Keywords: kberrmsg kbdatabase kbaspobj kbprb KB190743