Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
我从第一页里面<span title="修改" onClick="window.open('productstypeedit.asp?id=<%=rs("id")%>','','width=1040,height=1000');" style="cursor:hand ">修改</span>第二页<%
py_id=trim(request.QueryString("id"))
set conn=server.CreateObject("adodb.connection")
conn.open MM_sdasfdataconn_string
'set rs=server.CreateObject("adodb.recordset")
sql="select * from productstype where id="&py_id
set rs=conn.execute(sql)
py_name=rs("py_name")
%>
(木木) 16:35:06
然后在第二页修改后提交给第三页更新
<%
id=trim(request.QueryString("id"))
name=trim(request.Form("name"))
set conn=server.CreateObject("adodb.connection")
conn.open MM_sdasfdataconn_string
up_sql="update productstype set py_naem='"&name&"' where id='"&id&"'"
conn.execute(up_sql )
