写入数据库失败!!急
除"tuijian"字段无法写入数据库外,其他都可以,代码哪里出错了?
<%
id=Trim(Request.Form("id"))
User=Trim(request.form("User"))
Hits=Trim(request.form("Hits"))
BigClassName=trim(request.form("BigClassName"))
SmallClassName=trim(request.form("SmallClassName"))
content=trim(request.form("content"))
Passed=trim(request.form("Passed"))
tuijian=trim(request.form("tuijian"))
dateTime=trim(request.form("dateTime"))
action=request("action")
title=request("title")
if BigClassName="" then
founderr=true
errmsg=errmsg+"<li>未指定新闻所属大类</li>"
end if
if Title="" then
founderr=true
errmsg="<li>新闻标题不能为空</li>"
end if
if Content="" then
founderr=true
errmsg=errmsg+"<li>新闻内容不能为空</li>"
end if
if founderr=false then
Title=dvhtmlencode(Title)
if Infotime<>"" and IsDate(Infotime)=true then
Infotime=CDate(Infotime)
else
Infotime=now()
end if
if Hits<>"" then
Hits=CLng(Hits)
else
Hits=0
end if
set rs=server.createobject("adodb.recordset")
select case Action
case "Add"
sql="select * from News where (id is null)"
rs.open sql,conn,1,3
rs.addnew
call SaveData()
rs.update
rs.close
set rs=nothing
response.redirect "News_Manage.asp"
case "Modify"
if ID<>"" then
sql="select * from News where id="&ID
rs.open sql,conn,1,3
if not (rs.bof and rs.eof) then
call SaveData()
rs.update
rs.close
set rs=nothing
response.redirect "News_Manage.asp"
else
founderr=true
errmsg=errmsg+"<li>找不到此新闻,可能已经被删除。</li>"
call WriteErrMsg()
end if
else
founderr=true
errmsg=errmsg+"<li>不能确定ID的值</li>"
call WriteErrMsg()
end if
Case else
founderr=true
errmsg=errmsg+"<li>没有选定参数</li>"
call WriteErrMsg()
end select
call CloseConn()
else
WriteErrMsg
end if
%>
<%
sub SaveData()
rs("Title")=Title
rs("Content")=Content
rs("User")=User
rs("BigClassName")=bigclassname
rs("SmallClassName")=SmallClassName
rs("datetime")=datetime
rs("Hits")=Hits
if tuijian="true" then
rs("tuijian")=true
else
rs("tuijian")=false
end if
if Passed="true" then
rs("Passed")=true
else
rs("Passed")=false
end if
rs("DefaultPicUrl")=DefaultPicUrl
end sub
%>