对后台消息进行修改，提交后总是提示“参数错误{ID=0}”找不到原因，不知什么情况，有哪位高手指点一下？

Question

Id = parseInt(Request.Form("Id"))

set rs = Server.CreateObject("adodb.recordset")

sql = "select * from ["& MainTb &"] where Id = "& Id

rs.open sql,conn,1,3

   if rs.EOf then

    Call V.AddError("Id","参数错误{Id="& Id &"}")

   End if

Answer 1

Id要不要加上单引号？

sql = "select * from ["& MainTb &"] where Id = '"& Id &"'"