level 1
手残冰DK
楼主
<HTML> <BODY>
<%
str = Request("ID")
shijian = Request("time")
changdi = Request("changdi")
bisaixiangmu = Request("bisaixiangmu")
price = Request("price")
set conn = Server.CreateObject("ADODB.Connection")
conn.Open("driver={Microsoft Access Driver (*.mdb)};dbq=" &_
Server.MapPath("my space.mdb"))
set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
sql = "UPDATE 门票信息表 SET time = " & shijian & ",changdi=" &_
changdi & ",bisaixiangmu=" & bisaixiangmu & "，price=" & price & " where ID=" & str
Response.Write(sql)
cmd.CommandText = sql
cmd.Execute()
Response.Redirect("商品管理.asp")
%>
</BODY> </HTML>
提示第十七行有错误
2015年01月22日 01点01分
1
<%
str = Request("ID")
shijian = Request("time")
changdi = Request("changdi")
bisaixiangmu = Request("bisaixiangmu")
price = Request("price")
set conn = Server.CreateObject("ADODB.Connection")
conn.Open("driver={Microsoft Access Driver (*.mdb)};dbq=" &_
Server.MapPath("my space.mdb"))
set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
sql = "UPDATE 门票信息表 SET time = " & shijian & ",changdi=" &_
changdi & ",bisaixiangmu=" & bisaixiangmu & "，price=" & price & " where ID=" & str
Response.Write(sql)
cmd.CommandText = sql
cmd.Execute()
Response.Redirect("商品管理.asp")
%>
</BODY> </HTML>
提示第十七行有错误