 |
|
|
个性化主页
|
SQL 列表无效 列名 'true' 无效。 /_ovc_op/sallers.asp，行 18
未解决
悬赏分:  0
-离问题结束还有: 0
|
|
| <!--#include file="config.asp"--> <!--#include file="select_inc.asp" --> <% select case request("act") case "show" sql="update salers set showif=true where id="&request("id")&"" response.write("sql="&sql) －－－－－这是第17行－－－－ conn.execute(sql） －－－－－这是第18行－－－－ response.Redirect(request.ServerVariables ("HTTP_REFERER")) case "shownot" sql="update salers set showif=false where id="&request("id")&"" conn.execute(sql) response.Redirect(request.ServerVariables("HTTP_REFERER")) end select %> <%select case request("Submit") case "添加" sql="select * from salers" set rs=server.createobject("adodb.recordset") rs.open sql,conn,1,3 rs.addnew rs("name")=request("name") rs("area")=request("sale") rs("address")=request("address") rs("tel")=request("tel") rs("content")=request("content") rs("sity")=request("sity") rs.update set rs=nothing response.Redirect("sallers.asp") case "更新" sql="select * from salers where id="&cint(request("id"))&"" set rs=server.createobject("adodb.recordset") rs.open sql,conn,1,3 rs("name")=request("name") rs("area")=request("sale") rs("address")=request("address") rs("tel")=request("tel") rs("content")=request("content") rs("sity")=request("sity") rs.update set rs=nothing response.Redirect(request.ServerVariables("HTTP_REFERER")) case "删除" sql="select * from salers where id="&cint(request("id"))&"" set rs=server.createobject("adodb.recordset") rs.open sql,conn,1,3 rs.delete rs.update set rs=nothing response.Redirect(request.ServerVariables("HTTP_REFERER")) case "排序" sql="select * from salers where id="&cint(request("id"))&"" set rs=server.createobject("adodb.recordset") rs.open sql,conn,1,3 rs("orderid")=request("orderid") rs.update set rs=nothing response.Redirect(request.ServerVariables("HTTP_REFERER")) end select %> －－－－－－后面内容我省略了－－－－－－－ |
|
| 提问者: 断︻$▅▆/db - 试用 二级 回答数: 0 | |