ACCESS数据查询

来源:百度知道 编辑:UC知道 时间:2024/05/24 17:01:07
access数据表中有:"name","tel","message","time"
现用表单输入"name","tel"点击提交按钮查询表中记录代码如下:
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="insert_1.asp">
搜索:<br>
name:
<input type="text" name="name">
tel:
<input type="text" name="tel">
<br>
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
</form>
</body>
</html>
insert_1.asp代码:
<%
name=request.form("nam

<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="insert_1.asp">
搜索:<br>
name:
<input type="text" name="txtname">
message:
<input type="text" name="txtmessage">
<br>
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
</form>
</body>
</html>
insert_1.asp代码:
<%
rename=request.form("txtname")
remessage=request.form("txtmessage")
set conn=server.createobject("adodb.connectio