sql2000中的bit类型问题

[bulls5988]

我在表中将pmember_id_real定义成bit型数据 默认值是0
当我用想获得表中pmember_id_real为0的数据
<%
Set rsss=Server.CreateObject("ADODB.RecordSet")
sql="select * from JOB_P_pmember"
rsss.open sql,conn,1,1

if rsss("pmember_id_real")=0 then
do while not rsss.eof
%>
<%=rsss("pmember_id")%> <%= rsss("pmember_login") %> <%= rsss("pmember_id_real") %>
<%
rsss.movenext
loop
%>
<%else%>
<%
response.Write("")
%>
缺输出了所有数据其中就包括pmember_id_real字段为1的pmember_login=bulls5988 pmember_id_real=True
明明是pmember_id_real=True为什么还会输出呢?

[sy_binbin]

if rsss("pmember_id_real")=true then

或

if rsss("pmember_id_real")=false then

忘了哪个代表0了

[bulls5988]

我想用pmember_id_real做为审核的状态 0为未审核 1为审核过了

[braveboy]

true 表1

[bulls5988]

无论用 rsss("pmember_id_real")=true 或者是 rsss("pmember_id_real")=false 都是输出所有数据

[bulls5988]

rsss("pmember_id_real")=true 无数据输出
rsss("pmember_id_real")=false 所有数据输出 不论pmember_id_real是1的还是是0的都输出了

[braveboy]

你的这个得看你的第一条记录是什么了
是这一条语句决定了的
if rsss("pmember_id_real")=0 then
do while not rsss.eof

[braveboy]

你的这个得看你的第一条记录是什么了,是这一条语句决定了的
if rsss("pmember_id_real")=0 then
do while not rsss.eof

[braveboy]

晕,发了两次
我想你的本意应该是这样的
do while not rs.eof
if rsss("pmember_id_real") then
response.write "为真"
else
response.write "为假"
end if
loop

[braveboy]

漏了句 rsss.movenext

[bulls5988]

<!--#include file="conn/conn.asp"-->
<%
pmember_id_real=rs("pmember_id_real")
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from JOB_P_pmember"
rs.open sql,conn,1,1
do while not rs.eof
%>
<%
if pmember_id_real=0 then
response.Write("false")
rs.movenext
loop
end if
%>

我把pmember_id_real改成int型 默认值是0 不允许空 我想让 pmember_id_real=1的 打印ture pmember_id_real=0的 打印false 为什么上面的程序不对啊

[braveboy]

Set   rs=Server.CreateObject("ADODB.RecordSet")  
sql="select * from  JOB_P_pmember"  
rs.open sql,conn,1,1  
do   while   not   rs.eof 
	pmember_id_real=rs("pmember_id_real") 
	if pmember_id_real=1   then
		response.Write("true")
	else
		response.Write("false")
	end if
	rs.movenext  
loop