谁能帮我看一下以下asp代码哪里出错了?

来源:百度知道 编辑:UC知道 时间:2024/05/19 15:28:49
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!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=gb2312" />
<title>会员登录处理</title>
</head>

<body>
<%
dim loginmode , member_id , password
dim Connobj , rsobj ,findError
loginmode = Request.form("cmdlogin")
select case loginmode
case "会员登录"
Member_id =request.form("member_id")
password = request.form("password")
<

strSql ="SELECT * FROM Customer WHERE Member_id ="& member_id & " AND password ="& password & " "

出错信息贴出来看看

connobj.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath ("ecommerce.mdb")
Set rsobj =Server.Creeateboject("ADODB.Recordset")
strSql ="SELECT * FROM Customer WHERE Member_id = " & member_id & " AND password = '"& password & "' "