帮忙看看:
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'news_ID=' 中。
/ht/admin/job/News.asp, 第 7 行
<!--#include file="../inc/conn_other.asp"--><head>
<link href=..\css\Admin_Style.css rel=STYLESHEET type=text/css>
</head>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from job where news_ID="&request("id")
rs.open sql,conn,3,1
%>
<TABLE width=460 border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD width=8></TD>
<TD vAlign=top width=560><DIV align=center>
<CENTER>
<TABLE height=400 cellSpacing=0 cellPadding=0 width=500 border=0>
<TBODY>
<TR>
<TD width=1 bgColor=#afafaf height=1></TD>
<TD bgColor=#afafaf height=1></TD>
<TD width=1 bgColor=#afafaf height=1></TD>
</TR>
<TR>
<TD width=1 bgColor=#afafaf></TD>
<TD width=534 height=398 align="center" vAlign=top bgColor=#f7f7f7><TABLE height=23 cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD></TD>
</TR>
</TBODY>
</TABLE>
<DIV align=center>
<CENTER>
</CENTER>
</DIV>
<TABLE height=30 cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD>招聘信息详细</TD>
</TR>
</TBODY>
</TABLE>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="147" height="18"><div align="center"> 招聘职位：</div></td>
<td width="348" height="18"><div align="left"><%=trim(rs("job_title"))%></div></td>
</tr>
<tr>
<td width="147" height="18"><div align="center"> 招聘人数：</div></td>
<td width="348" height="18"><div align="left"><%=trim(rs("job_num"))%></div></td>
</tr>
<tr>
<td width="147" height="18"><div align="center"> 主要负责：</div></td>
<td width="348" height="18"><div align="left"><%=trim(rs("job_job"))%></div></td>
</tr>
<tr>
<td width="147" height="18"><div align="center"> 学历要求：</div></td>
<td width="348" height="18"><div align="left"><%=trim(rs("job_tech"))%></div></td>
</tr>
<tr>
<td width="147" height="18"><div align="center"> 工作经验：</div></td>
<td width="348" height="18"><div align="left"><%=trim(rs("job_work"))%></div></td>
</tr>
<tr>
<td height="24"><div align="center"><font color="red">发表日期：</font> </div></td>
<td height="24"><font color="red"><%=rs("job_Date")%></font></td>
</tr>
<tr>
<td height="24" valign="top"><div align="center">相关内容：</div></td>
<td height="24"><%=trim(rs("job_Content"))%></td>
</tr>
<tr>
</tr>
<tr>
<td height="24" colspan="2"><div align="center"><font color="#000000"><a href="javascript:window.close()"><u>关闭窗口</u></a></font></div></td>
</tr>
</table></TD>
<TD width=1 bgColor=#afafaf></TD>
</TR>
<TR>
<TD width=1 bgColor=#afafaf height=1></TD>
<TD bgColor=#afafaf height=1></TD>
<TD width=1 bgColor=#afafaf
height=1></TD>
</TR>
</TBODY>
</TABLE>
</CENTER>
</DIV></TD>
<TD vAlign=top width=10><IMG height=218
src="../images/frame_equipment_img1.gif" width=8></TD>
</TR>
<TR>
<TD align=right colSpan=2><IMG height=10
src="../images/frame_equipment_img2.gif" width=270></TD>
<TD align=right width=10></TD>
</TR>
</TBODY>
</TABLE>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
