Question

语法错误 (操作符丢失) 在查询表达式 'userid=' 中。

<!--#include file="index_top.asp" -->
<!--#include file="conn2.asp"-->
<%

dim rencai_id
rencai_id=request.querystring("id")
dim oJZ_rs1,sJZ_sql1
Set oJZ_rs1=Server.CreateObject("ADODB.Recordset")
userid=session("card_id")
If userid="" or IsNull(userid) Then
Response.Write ("<script>alert(' 操作错误 \n\n 可能您还没有登陆或者登陆超时 ');history.back();</script>")
Response.End
End If
sJZ_sql1="SELECT * FROM rencai_info "
if request("step")="user" then
sJZ_sql1=sJZ_sql1&" where userid="&session("card_id")&""
else
sJZ_sql1=sJZ_sql1&" where id="&rencai_id

end if

oJZ_rs1.Open sJZ_sql1,conn,1,1

if oJZ_rs1.recordcount > 0 and oJZ_rs1.eof then
response.Write("<script language=javascript>alert('您还没有添加个人信息~！');history.back();</script>")
response.end
end if
%>
<%if session("card_no")<>"" then%>
<!--#include file="user_top.asp"-->
<%else%>
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="33" align="center" background="images/info_mid.gif"><a href="zp_rencai_all.asp">全部人才信息</a> | <a href="zp_rencai_tj.asp">推荐人才</a> | <a href="gw_fabu.asp">发布招聘信息</a> | <a href="toushu.asp">投诉建议</a></td>
</tr>
</table>
<%end if%>

Answer 1

估计是调用的问题
在oJZ_rs1.Open sJZ_sql1,conn,1,1 之前用
response.Write(sJZ_sql1)
respopnse.end()

Answer 2

没法帮你调试，你可以在oJZ_rs1.Open sJZ_sql1,conn,1,1 之前用
response.Write(sJZ_sql1)
respopnse.end()
输出sql语句看看是哪里错误了