菜鸟建站求助
菜鸟建站求助 Microsoft OLE DB Provider for SQL Server 错误 '80040e14' 第 1 行: '=' 附近有语法错误。 /admin/User/Member_info.asp，行 10 代码如下菜鸟建站求助
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'
第 1 行: '=' 附近有语法错误。
/admin/User/Member_info.asp，行 10 代码如下
<!--#include file="../../conn/conn.asp" -->
<!--#include file="../../Inc/Commoncode.asp" -->
<!--#include file="../checkvalid.asp" -->
<%If Not (FRAdminLevel(201) and FRAdminLevel(202)) Then
Call ErrorMsg()
End If
member_id=trim(request("id"))
sql="select * from JOB_member where member_id="&member_id
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<html>
<head>
<title>查看会员信息</title>
<meta http-equiv="Content-Type" c>
<LINK href=../css/style.css rel=stylesheet type="text/css">
</head>
<body>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="1" class="tableBorder">
<tr>
<th height="25" class="tableHeaderText" colspan="2"> 查看会员信息 </th>
</tr>
<tr>
<td width="160" align="right">通行证帐号：</td>
<td width="576"><%=rs("member_login")%> </td>
</tr>
<tr>
<td align="right">通行证状态：</td>
<td><%if rs("Member_Auditing")=0 then%>未审核<%else%>已审核<%end if%></td>
</tr>
<tr>
<td align="right">电子邮箱：</td>
<td><%=rs("member_email")%> </td>
</tr>
<tr>
<td align="right">密码保护问题：</td>
<td><%=rs("Member_Question")%> </td>
</tr>
<tr>
<td align="right">密码保护答案：</td>
<td><%=rs("Member_Answer")%> </td>
</tr>
<tr>
<td align="right">帐户类型：</td>
<td><%Select Case rs("Member_typeid")
Case 1
Response.Write("个人会员")
Case 2
Response.Write("企业会员")
Case 3
Response.Write("院校会员")
Case 4
Response.Write("培训机构")
Case Else
Response.Write("未选择类别")
End Select%></td>
</tr>
<tr>
<td align="right">会员名称：</td>
<td><%=rs("Member_name")%> </td>
</tr>
<tr>
<td align="right">注册时间：</td>
<td><%=rs("Member_regdate")%> </td>
</tr>
<tr>
<td align="right">登陆次数：</td>
<td><%=rs("Member_loginnum")%>次</td>
</tr>
<tr>
<td align="right">最后登陆时间：</td>
<td><%=rs("Member_logindate")%> </td>
</tr>
<tr>
<td align="right">最后登陆IP：</td>
<td><%=rs("Member_loginIP")%> </td>
</tr>
<tr>
<td align="right">帐户余额：</td>
<td><%=rs("Member_balance")%>元</td>
</tr>
<tr>
<td align="right">积分：</td>
<td><%=rs("Member_integral")%>分</td>
</tr>
<tr>
<td align="right">可消费点数：</td>
<td><%=rs("Member_consumenums")%>点</td>
</tr>
<tr>
<td align="right">账户状态：</td>
<td><%if rs("Member_flag")=0 then%>未审核<%else%>已审核<%end if%></td>
</tr>
<tr>
<td align="right">开始日期：</td>
<td><%=rs("Member_startdate")%> </td>
</tr>
<tr>
<td align="right">结束日期：</td>
<td><%=rs("Member_enddate")%> </td>
</tr>
<tr>
<td colspan="2" align="center"><input name="Submit3" type="button" class="inputs" id="Submit3" style="cursor:hand"value="关 闭" /></td>
</tr>
</table>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
页:
[1]