大世界宾馆:帮我找错误,ASP代码,谢谢

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/28 03:20:19
<!--#include file="conn.asp"-->
<%
if request.QueryString("no")="eshop" then
id=request("id")
title=request("title")
content=request("content")

If title="" Then
response.write "SORRY <br>"
response.write "请输入更新内容的标题!!<a href=""javascript:history.go(-1)"">返回重输</a>"
response.end
end if
If content="" Then
response.write "SORRY <br>"
response.write "内容不能为空!!<a href=""javascript:history.go(-1)"">返回重输</a>"
response.end
end if

set rs=server.CreateObject("adodb.recordset")
sql="select * from news where id="&id
rs.open sql,conn,1,3

rs("title")=title
rs("newclass")=newclass
rs("content")=content
rs("time")=now()
rs.update
rs.close
response.Write"<script language='javascript'>alert('修改新闻成功!');location.href('Newslist.asp');</script>"
end if
%>
<%
id=request.QueryString("id")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from news where id="&id,conn,3,3
%>
<table width="650" border="0" align="center" cellpadding="2" cellspacing="0">
<form name="form1" method="post" action="?no=eshop"><input type="hidden" name="id" value="<%=id%>">
<tr>
<td colspan="3" align="center">修改文章</td>
</tr>
<tr>
<td width="60" align="right">标题</td>
<td width="23" align="center"><font color="#FF0000">*</font></td>
<td width="553"><input name="title" type="text" id="title" value="<%=rs("title")%>"></td>
</tr>
<tr>
<td align="right">类别</td>
<td align="center"><font color="#FF0000">*</font></td>
<td><select name="newclass" id="newclass">
<%set rs1=server.CreateObject("adodb.recordset")
rs1.Open "select * from newsclass order by id",conn,1,1
do while not rs1.EOF %>
<option value=<%=rs1("ID")%>><%=trim(rs1("Name"))%></option>
<% rs1.MoveNext
loop
rs1.close
%>
</select></td>
</tr>
<tr>
<td align="right">内容</td>
<td align="center"><font color="#FF0000">*</font></td>
<td>
<textarea name="content" style="display:none"><%=server.HTMLEncode(rs("content"))%></textarea>
<iframe ID="eWebEditor1" src="WebEdit/ewebeditor.asp?id=content&style=" frameborder="0" scrolling="no" width="550" HEIGHT="350"></iframe>
</td>
</tr>
<tr align="center">
<td colspan="3"><input type="submit" name="Submit" value="提交">

<input type="reset" name="Submit2" value="重置"></td>
</tr>
</form>
</table>
======================
提示错误:错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'id=' 中。
/www/admin/editnews.asp, 第 42 行

rs.open ,conn,3,3

这是个什么东西

这样
sqlstr = "select * from news where id='"&id&"'"
rs.open sqlstr,conn,3,3

写程序要规范

sqlstr = "select * from news where id='id'"

TO:wu_wang
rs.open "select * from news where id="&id,conn,3,3
这行这样写OK的!~~~~~~~~~~~~

对呀,那样写是正确的
但是为何出现那种种错呢