<% if request("edit") = "yes" then sql2 = " Select * from T_product " sql2 = sql2 & " where product_id =" & request("product_id") set rs2=server.createobject("adodb.recordset") rs2.open sql2,oConn,3,1,1 product_id = rs2("product_id") type_id = rs2("type_id") 'sql2 = "select * from T_product_type where product_id = " & request("product_id") 'response.write sql2 'response.end 'Create_Ado rs2, sql2, 3,1,1 end if if request("product_title") <> "" then if cstr(trim(request("old_product_title"))) <> cstr(trim(request("product_title"))) then sql4 = "select * from T_product where product_title = '" & request("product_title") & "' and product_id = " & request("product_id") set rs4=server.createobject("adodb.recordset") rs4.open sql4,oConn,3,1,1 'Create_Ado rs4, sql4, 3,1,1 if not rs4.eof then Response.Write "" response.end end if end if sql5 = "Select * from T_product where product_id = " & request("product_id") set rs15=server.createobject("adodb.recordset") rs15.open sql5,oConn,3,2,1 'Create_Ado rs1, sql, 3,2,1 rs15("type_id") = request("type_id") rs15("product_title") = request("product_title") rs15("product_detail") = request("product_detail") rs15("seq") = request("seq") rs15("valid") = request("valid") rs15.update Response.Write "" %> `
<% response.end rs15.Close Set rs15 = Nothing end if %>
編輯類別
類別:
*
<% sql = "Select * from T_type " set rs=server.createobject("adodb.recordset") rs.open sql,oConn,3,1,1 do while not rs.eof %>
" <% if cstr(type_id) = cstr(rs("type_id")) then response.write "selected" end if %>><%=rs("type_name")%>
<% rs.movenext loop %>
類別名稱:
*
">
">
">
產品簡介:
*
<%=rs2("product_detail")%>
次序 :
*
">
狀況:
> 有效
> 無效