注册 登录
编程论坛 ASP技术论坛

[求助]后台添加文字提示错误,请问各位怎么回事

haiwei521 发布于 2009-11-17 19:41, 476 次点击
Microsoft VBScript 编译器错误 (0x800A03EA)语法错误

<%

dim action,id,Layout,Layout_e
Layout="showproduct"
Layout_e="e_showproduct"
id=request.QueryString("id")
action=request.QueryString("action")
select case action
'添加
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from yongsheng_products",conn,1,3
rs.AddNew
rs("anclassid")=int(request("anclassid"))
if request("nclassid")<>"" then
   rs("nclassid")=int(request("nclassid"))
end if
rs("cpmc")=trim(request("cpmc"))
rs("e_cpmc")=trim(request("e_cpmc"))
rs("cpbh")=trim(request("cpbh"))
rs("Keywords")=trim(request("Keywords"))
rs("e_Keywords")=trim(request("e_Keywords"))
rs("pic")=trim(request("pic"))
rs("intro")=trim(request("intro"))
rs("e_intro")=trim(request("e_intro"))
if request("show")=1 then
rs("show")=true
else
rs("show")=false
end if
if request("sort")<>"" then
rs("sort")=trim(request("sort"))
else
rs("sort")=0
end if
rs.Update
id=rs("id")
rs.Close
set rs=nothing
response.write"<script>alert('添加成功!');location.href='pro_addbook.asp';</script>"
response.End //错误

%>

<%
'编辑
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from yongsheng_products where id="&id,conn,1,3
rs("anclassid")=int(request("anclassid"))
if request("nclassid")<>"" then
   rs("nclassid")=int(request("nclassid"))
   else
   rs("nclassid")=0
end if
rs("cpmc")=trim(request("cpmc"))
rs("e_cpmc")=trim(request("e_cpmc"))
rs("cpbh")=trim(request("cpbh"))
rs("Keywords")=trim(request("Keywords"))
rs("e_Keywords")=trim(request("e_Keywords"))
rs("pic")=trim(request("pic"))
rs("intro")=trim(request("intro"))
rs("e_intro")=trim(request("e_intro"))
if request("show")=1 then
rs("show")=true
else
rs("show")=false
end if
if request("sort")<>"" then
rs("sort")=trim(request("sort"))
else
rs("sort")=0
end if
rs.Update
rs.Close
set rs=nothing
response.write"<script>alert('修改成功!');location.href='pro_managebook.asp';</script>"
response.End   //错误
%>
2 回复
#2
msgj2009-11-17 21:38
Select Case 语句应该有与之匹配的 End Select 语句。

#3
haiwei5212009-11-17 22:07
谢谢老师可以了,忘记加了
1