FROM 子句语法错误！请教！

显示全部楼层 · 2011-6-17 06:30:29

会员注册测试时出现:错误类型：
MicrosoftOLEDBProviderforODBCDrivers(0x80040E14)
[Microsoft][ODBCMicrosoftAccessDriver]FROM子句语法错误。
/new_member.asp,第33行

varMM_LoginAction=Request.ServerVariables(\"URL\");
if(Request.QueryString!=\"\")MM_LoginAction=\"?\"Server.HTMLEncode(Request.QueryString);
varMM_valUsername=String(Request.Form(\"id\"));
if(MM_valUsername!=\"undefined\"){
varMM_fldUserAuthorization=\"\";
varMM_redirectLoginSuccess=\"loginok.html\";
varMM_redirectLoginFailed=\"loginerror.html\";
varMM_flag=\"ADODB.Recordset\";
varMM_rsUser=Server.CreateObject(MM_flag);
MM_rsUser.ActiveConnection=MM_member_STRING;
MM_rsUser.Source=\"SELECTid,password\";
if(MM_fldUserAuthorization!=\"\")MM_rsUser.Source=\",\"MM_fldUserAuthorization;
MM_rsUser.Source=\"FROMjoinWHEREid=\'\"MM_valUsername.replace(/\'/g,\"\'\'\")\"\'ANDpassword=\'\"String(Request.Form(\"password\")).replace(/\'/g,\"\'\'\")\"\'\";
MM_rsUser.CursorType=0;
MM_rsUser.CursorLocation=2;
MM_rsUser.LockType=3;
MM_rsUser.Open();
if(!MM_rsUser.EOF||!MM_rsUser.BOF){
//usernameandpasswordmatch-thisisavaliduser
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\"
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginSuccess);
}
MM_rsUser.Close();这是33行的代码
Response.Redirect(MM_redirectLoginFailed);
}
%
请教怎么解决，谢谢！

千问 · 2011-6-17 06:30:29

MM_rsUser.Source=\"FROMjoinWHEREid=\'\"MM_valUsername.replace(/\'/g,\"\'\'\")..
?
你的表名称叫\"join\"?那么改为:

MM_rsUser.Source=\"FROM[join]WHEREid=\'\"MM_valUsername.replace(/\'/g,\"\'\'\")..