asp怎么判断写入到access是的值是否为空
<% if request.querystring("action")="add" then
if trim(request.form("info_name"))="" then
response.Write "<script language=javascript>alert('信息名称不能为空!');window.location.href='news_add.asp';</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from news_info "
rs.open sql,conn,1,3
rs.addnew
if request.Form("sort_id")<>"" then
rs("sort_id")=trim(request.form("sort_id"))
end if
if trim(request.form("info_name"))<>"" then rs("info_name")=server.HTMLEncode(trim(request.form("info_name")))
if trim(request.form("info_sort"))<>"" then rs("info_sort")=server.HTMLEncode(trim(request.form("info_sort")))
rs("small_img")=server.HTMLEncode(trim(request.form("small_img")))
rs("big_img")=server.HTMLEncode(trim(request.form("big_img")))
rs("big_img2")=server.HTMLEncode(trim(request.form("big_img2")))
if trim(request.form("tuijian"))<>"" then rs("tuijian")=server.HTMLEncode(trim(request.form("tuijian")))
if trim(request.form("pass"))<>"" then rs("pass")=server.HTMLEncode(trim(request.form("pass")))
if trim(request.form("sx"))<>"" then rs("sx")=server.HTMLEncode(trim(request.form("sx")))
rs("info_content")=trim(request.form("info_content"))
rs.update
response.Write "<script language=javascript>alert('添加信息成功!');window.location.href='news_add.asp';</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%>
能读取数据库的东西,却写不进去