主题:[讨论]asp的问题~~偶东拼西凑的脚本!
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<%
set conn=server.CreateObject("ADODB.Connection")
%>
<!-- #include file="conn.asp" -->
<head>
<meta http-equiv="Content-Language" content="zh-cn" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Submit success</title>
<style type="text/css">
.style2 {
font-family: 微软雅黑;
font-size: small;
}
</style>
</head>
<body>
<%
set rst=Server.CreateObject("ADODB.recordset")
set rst1=conn.Execute("insert into user_acc(username,ad_acc,friwo_acc,hostname,dept,ext,closed_by,closed_time,request,status) values ('" & request. form("username") & "','" & request.form("ad_acc") & "','" & request.form("friwo_acc") & "','" & request.form("hostname") & "','" & request.form("dept") & "','" & request.form("ext") & "','" & request.form("closed_by") & "','" & request.form("closed_time") & "','" & request.form("request") & "','" & request.form("status") & "')")
%>
<p style="width: 121px" class="style2">Submit success</p>
<p style="width: 174px" class="style2">Error, please submit it again</p>
</body>
</html>
运行的时候提示
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/result.asp, line 23
该咋整呢????
<html xmlns="http://www.w3.org/1999/xhtml">
<%
set conn=server.CreateObject("ADODB.Connection")
%>
<!-- #include file="conn.asp" -->
<head>
<meta http-equiv="Content-Language" content="zh-cn" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Submit success</title>
<style type="text/css">
.style2 {
font-family: 微软雅黑;
font-size: small;
}
</style>
</head>
<body>
<%
set rst=Server.CreateObject("ADODB.recordset")
set rst1=conn.Execute("insert into user_acc(username,ad_acc,friwo_acc,hostname,dept,ext,closed_by,closed_time,request,status) values ('" & request. form("username") & "','" & request.form("ad_acc") & "','" & request.form("friwo_acc") & "','" & request.form("hostname") & "','" & request.form("dept") & "','" & request.form("ext") & "','" & request.form("closed_by") & "','" & request.form("closed_time") & "','" & request.form("request") & "','" & request.form("status") & "')")
%>
<p style="width: 121px" class="style2">Submit success</p>
<p style="width: 174px" class="style2">Error, please submit it again</p>
</body>
</html>
运行的时候提示
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/result.asp, line 23
该咋整呢????