<% prod_id = request.querystring("prod_id") qryEdit = "select * from products where prod_id = "& prod_id &"" set rsEdit = conn.execute(qryEdit) %>

Product Edit.     Product code : "> Preview : <%=rsEdit("prod_describe")%> Detail : <%=rsEdit("prod_detail")%> PDF Name : "size="60"> PDF Link : "size="60">     Band : <% qryGrp = "select * from bands" set rsGrp = conn.execute(qryGrp) sel = "" do while not rsGrp.eof if cInt(rsGrp("band_id")) = cInt(rsEdit("band_id")) then sel = "selected" end if%> " <%=sel%>><%=rsGrp("band_name")%> <% sel = "" rsGrp.movenext:loop set rsGrp = nothing %> Image : *** (width 200 pixel) ***     <% if len( rsEdit("prod_picture") ) > 0 then response.write imgsrc("../" & rsEdit("prod_picture"), rsEdit("prod_picturex"), rsEdit("prod_picturey"), 200, 0) end if %>