Question

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

<%
if not session("checked")="yes" then
response.Redirect "denglu.asp"
else
%>

<!-- #include file="upload_5xsoft.inc" -->

<%
dim upload,p_id,p_instr,uploadpath,jpeg,exec
set upload=new upload_5xsoft

set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("admin.mdb")&";password=111"
set rs=server.createobject("adodb.recordset")
id=upload.form("id")
exec="select * from hmc where id="&id""
rs.open exec,conn,1,3

提示我是行18，也就是最后一句。但是实在不知道应该怎么改这段。求高手帮忙

Answer 1

改为
exec="select * from hmc where id='"&id&"'"

试试

追问

试过，改成你写的那样也一样。