Question

asp表单提交数据库显示一条记录的每个字段都为空值~怎么回事...有谁帮帮忙~急!

tijiao.htm:
<form id="form1" name="form" method="post" action="action.asp">
<table width="92%" height="160" border="1" align="center" cellpadding="0" cellspacing="0" bordercolordark="#FFFFFF" bordercolorlight="#666666">
<tr>
<td colspan="4"><div align="center">测试用的表单</div></td>
</tr>
<tr>
<td width="8%">姓名：</td>
<td width="39%"><input type="text" name="name" /></td>
<td width="9%">家庭住址：</td>
<td width="44%"><input type="text" name="address" /></td>
</tr>
<tr>
<td>性别：</td>
<td><input type="text" name="sex" /></td>
<td>联系电话：</td>
<td><input type="text" name="tel" /></td>
</tr>
<tr>
<td>年龄：</td>
<td><input type="text" name="nianling" /></td>
<td>E-mail:</td>
<td><input type="text" name="email" /></td>
</tr>
<tr>
<td>出生年月：</td>
<td><input type="text" name="both" /></td>
<td>特长：</td>
<td><input type="text" name="fev" /></td>
</tr>
<tr>
<td colspan="3"><input type="submit" name="Submit" value="提交" /></td>
<td><input type="reset" name="Submit2" value="重置" /></td>
</tr>
</table>
</form>

action.asp:
<!--#include file="test.asp"-->
<%
dim rs,sql,rsRepeat
names=request.Form("name")
address=request.Form("address")
sex=request.Form("sex")
tel=request.Form("tel")
nianling=request.Form("nianling")
email=request.Form("email")
both=request.Form("both")
fev=request.Form("fev")

set rs=Server.CreateObject("Adodb.Recordset")
sql="select * from data "
rs.open sql,conn,1,3
rs.addnew
rs("name")=names
rs("address")=address
rs("sex")=StrReplace(sex)
rs("tel")=StrReplace(tel)
rs("nianling")=StrReplace(nianling)
rs("email")=StrReplace(email)
rs("both")=StrReplace(both)
rs("fev")=StrReplace(fev)

rs.update
rs.close
set rs=nothing
WriteMsg("·Submitted Success!，Come in<a href=main.asp><font color='red'>Home]</font></a>Back.")
%>

test.asp:
<%
Response.Buffer=True
On Error Resume Next
dbfolder="Data/"
dbname="tests.mdb"
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(dbfolder&dbname)
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connstr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "<p style='font-size:9pt' align=center>数据库连接出错！</p>"
Response.Write "<p style='font-size:9pt' align=center>可能出错原因：数据库位置或名称不对、数据库损坏！</p>"
Response.End
End If%>

Answer 1

你把数据类型都转成STR干什么，如果你数据库中设置的字段类型不一样，就会出错，你自己好好查查你数据库中相应字段的类型，并在update之将将类型转换好就OK了

Answer 2

你的存储过程写了么?你的数据库访问方法写了么?
写的时候调入接口正确么?
查查自己编写的各个接口地方,你会找到错误的!