<%
prod_id = request.querystring("prod_id")
qryEdit = "select * from products where prod_id = "& prod_id &""
set rsEdit = conn.execute(qryEdit)
%>
Product Detail..
Title :
<%=rsEdit("prod_code")%>
Detail :
<%=rsEdit("prod_detail")%>
specification
:
<%=rsEdit("prod_specName")%>
Band :
<%
qryGrp = "select * from bands where band_id = "& rsEdit("band_id") &""
set rsGrp = conn.execute(qryGrp)
if not rsGrp.eof then
response.write rsGrp("band_name")
end if
set rsGrp = nothing
%>
<%
if len(rsEdit("prod_picture")) > 0 then
response.write imgsrc("../" & rsEdit("prod_picture"), rsEdit("prod_picturex"), rsEdit("prod_picturey"), 200, 0)
end if
%>
