Question

ASP如何判断ACCESS表中的值不为空值

ASP如何判断ACCESS表中的值不为空值

Answer 1

set
rs
=
server.createobject("adodb.recordset")
sql
=
"select
姓名
from
表
where
(
姓名
=
''
or
姓名
is
null
)"
rs.open
sql,conn,0,1
if
rs.eof
then
response.write("没有找的姓名为空的记录")
else
response.write("存在姓名为空的记录")
end
if
rs.close()
set
rs
=
nothing

Answer 2

if not Isnull(rs("字段名称")) Then

Response.write(rs("字段名称"))

end if

Answer 3

select * from where id is not null

Answer 4

id is not null