[ODBC Microsoft Access Driver] 标准表达式中数据类不匹配！

我做了个用户登录界面，用的dw，但出现了错误，弄了好几天，弄不出来，求哪位大神帮忙啊！错误是：
Microsoft OLE DB Provider for ODBC Drivers
错误 '80040e07'
[Microsoft][ODBC Microsoft Access Driver] 标准表达式中数据类型不匹配。
/liuyanban/default.asp，行 31
我的原代码是：
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>

<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_ss_STRING;
Recordset1.Source = "SELECT * FROM Usersheet";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
<%
// *** Validate request to log in to this site.
var MM_LoginAction = Request.ServerVariables("URL");
if (Request.QueryString!="") MM_LoginAction += "?" + Server.HTMLEncode(Request.QueryString);
var MM_valUsername=String(Request.Form("textfield"));
if (MM_valUsername != "undefined") {
var MM_fldUserAuthorization="";
var MM_redirectLoginSuccess="main.asp";
var MM_redirectLoginFailed="cuowu.html";
var MM_flag="ADODB.Recordset";
var MM_rsUser = Server.CreateObject(MM_flag);
MM_rsUser.ActiveConnection = MM_ss_STRING;
MM_rsUser.Source = "SELECT LoginName, UserPass";
if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," + MM_fldUserAuthorization;
MM_rsUser.Source += " FROM Usersheet WHERE LoginName='" + MM_valUsername.replace(/'/g, "''") + "' AND UserPass='" + String(Request.Form("textfield2")).replace(/'/g, "''") + "'";
MM_rsUser.CursorType = 0;
MM_rsUser.CursorLocation = 2;
MM_rsUser.LockType = 3;
MM_rsUser.Open();
if (!MM_rsUser.EOF || !MM_rsUser.BOF) {
// username and password match - this is a valid user
Session("MM_Username") = MM_valUsername;
if (MM_fldUserAuthorization != "") {
Session("MM_UserAuthorization") = String(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value);
} else {
Session("MM_UserAuthorization") = "";
}
if (String(Request.QueryString("accessdenied")) != "undefined" && false) {
MM_redirectLoginSuccess = Request.QueryString("accessdenied");
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginSuccess);
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginFailed);
}
%>
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>
<body>
<form ACTION="<%=MM_LoginAction%>" METHOD="POST">
<table width="942" height="418" border="0">
<tr>
<td colspan="5"><div align="center">管理员登陆</div></td>
</tr>
<tr>
<td width="46"> </td>
<td width="110">用户名：</td>
<td width="667"> <input type="text" name="textfield" /></td>
<td width="96"> </td>
<td width="1"> </td>
</tr>
<tr>
<td> </td>
<td>密码：</td>
<td> <input type="password" name="textfield2" /></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> <input type="submit" name="Submit" value="登陆" />
<input type="reset" name="Submit2" value="重置" /> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></form>
</body>
</html>
<%
Recordset1.Close();
%>

检查数据库和 sql 语句
字符要用 ' 括起来，数字不要用！这里的内型指的都是数据库中表的字段类型

不感兴趣

开通SVIP免广告

类型不匹配一般都是sql语句有问题！

扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频！

4回复贴，共1页

<<返回asp吧

分享到:

日	一	二	三	四	五	六