Question

asp写入数据库代码有什么问题？？？？

<%if action="add" then
Quarters=trim(request.Form("Quarters"))
Uname=trim(request.Form("Name"))
Sex=trim(request.Form("Sex"))
Marry=trim(request.Form("Marry"))
Birthday=trim(request.Form("Birthday"))
Stature=trim(request.Form("Stature"))
School=trim(request.Form("School"))
Studydegree=trim(request.Form("Studydegree"))
Specialty=trim(request.Form("Specialty"))
Gradyear=trim(request.Form("Gradyear"))
Residence=trim(request.Form("Residence"))
Edulevel=trim(request.Form("Edulevel"))
Edulevel=trim(ChangeChr(Edulevel))
Experience=trim(request.Form("Experience"))
Experience=trim(ChangeChr(Experience))
Phone=trim(request.Form("Phone"))
Mobile=trim(request.Form("Mobile"))
Email=trim(request.Form("Email"))
Add=trim(request.Form("Add"))
Postcode=trim(request.Form("Postcode"))
'=================================
set rs=server.createobject("adodb.recordset")
sql="select * from HrDemandAccept"
rs.open sql,conn,1,3
rs.addnew
rs("Quarters")=Quarters
rs("name")=Uname
rs("Sex")=Sex
rs("Marry")=Marry
rs("Birthday")=Birthday
rs("Stature")=Stature
rs("School")=School
rs("Studydegree")=Studydegree
rs("Specialty")=Specialty
rs("Gradyear")=Gradyear
rs("Residence")=Residence
rs("Experience")=Experience
rs("Edulevel")=Edulevel
rs("Experience")=Experience
rs("Phone")=Phone
rs("Mobile")=Mobile
rs("Email")=Email
rs("Add")=Add
rs("Postcode")=Postcode
rs("Adddate")=date()
rs.update
rs.close
set rs=nothing
response.write"<SCRIPT language=JavaScript>alert('您的简历提交成功，如果合适我们会尽快通知您面试!');"
response.write"javascript:history.go(-2)</SCRIPT>"
else
%>
不确定，而且提交空的记录都写不进数据库。所以请大家帮帮忙。

Answer 1

if action="add" 这句

确定action能获取到值吗

action获取值"add"的途径？
如果是从网址中获取，需写成request.querystring("action")="add"
若果是从提交页的表单中获取，需写成request.form("action")="add"

或者你写成request("action")="add" 试试

Answer 2

从这里看没什么问题
如果写不进数据库可能是你的值可能和数据库定义的不一致
或者是文本字符长度超出你数据库定义的长度