求助，单选按钮组问题~~在线等

[bychgh]

<table width="200">
<tr>
<td><label>
<input type="radio" name="RadModify" value="false" id="Radmsconfig_0">
未完整</label><label>
<input type="radio" name="RadModify" value="true" id="Radmsconfig_1">
完整</label></td>
</tr>
</table>


if request("RadModify")="false" then
mywhere=mywhere & " and company_isModify="False" "
else
mywhere=mywhere & " and company_isModify="True" "
end if


sql语句拼接是
mywhere="and company_state<>1 "
sql="select * from Company where company_id >1 "&mywhere&" "

company_isModify在数据中是 bit类型，选中一个单选按钮时，company_isModify 应该是等于什么，
mywhere=mywhere & " and company_isModify='False' "
改成单引号也查询不出来

[youyou2404]

company_isModify = 1
bit 只能是0 和 1

[youyou2404]

if request("RadModify")="false" then
mywhere=mywhere & " and company_isModify=0 "
else
mywhere=mywhere & " and company_isModify=1 "
end if

[xshf12345]

if request("RadModify")="false" then
mywhere=mywhere & " and company_isModify='1' "

[toury]

if request("RadModify")="false" then
mywhere=mywhere & " and company_isModify=false "
else
mywhere=mywhere & " and company_isModify=true "
end if

[toury]

或者
if request("RadModify")="false" then
mywhere=mywhere & " and company_isModify=0"
else
mywhere=mywhere & " and company_isModify=-1"
end if

[一把编程的菜刀]

false或者true型不能用双引号或者单引号
只能是直接等于false或者true或者0或者1

[toury]

[Quote=引用 6 楼 chinmo 的回复:]

false或者true型不能用双引号或者单引号
只能是直接等于false或者true或者0或者1
[/Quote]

是这样。
更简单一点的话，这样写：
<%
mywhere=mywhere & " and company_isModify=" & eval(request("RadModify"))
%>

[bychgh]

多谢~~~~~~~~