<% v_Pic = request("txtpic") v_ProdID = request("product_id") v_ColorCode = request("color_code_n") Set DBConn = Server.CreateObject("ADODB.Connection") Set ItemRs = Server.Createobject("ADODB.Recordset") DBConn.Open Session("DSN") Sql = "select p.*,b.* from products_colors p,brands b where p.brand_id = b.brand_id and p.product_id =" & v_ProdID & " and p.color_code_n='" & v_ColorCode & "'" & " order by product_color_id asc" ItemRs.open Sql,DBconn %>
After zooming, click and drag the image in any direction to view more detail.
/<%=Itemrs.fields("pic2")%>.jpg','<%=Itemrs.fields("pic2")%>')" onMouseover=borderit(this,'Gainsboro') onMouseout=borderit(this,'White') class="menulines"> <%if Itemrs.fields("pic2") <> "" then%> /<%=Itemrs.fields("pic2")%>.jpg&product_id=<%=v_ProdID%>&color_code_n=<%=v_ColorCode%>'" SRC="Shades/ProductImages/<%=Itemrs.fields("brand_id")%>/<%=Itemrs.fields("pic2")%>.jpg" vspace=8 > <%end if%> /<%=Itemrs.fields("pic3")%>.jpg','<%=Itemrs.fields("pic3")%>')" onMouseover=borderit(this,'Gainsboro') onMouseout=borderit(this,'White') class="menulines"> <%if Itemrs.fields("pic3") <> "" then%> /<%=Itemrs.fields("pic3")%>.jpg&product_id=<%=v_ProdID%>&color_code_n=<%=v_ColorCode%>'" SRC="Shades/ProductImages/<%=Itemrs.fields("brand_id")%>/<%=Itemrs.fields("pic3")%>.jpg" vspace=8 > <%end if%> /<%=Itemrs.fields("pic4")%>.jpg','<%=Itemrs.fields("pic4")%>')" onMouseover=borderit(this,'Gainsboro') onMouseout=borderit(this,'White') class="menulines"> <%if Itemrs.fields("pic4") <> "" then%> /<%=Itemrs.fields("pic4")%>.jpg&product_id=<%=v_ProdID%>&color_code_n=<%=v_ColorCode%>'" SRC="Shades/ProductImages/<%=Itemrs.fields("brand_id")%>/<%=Itemrs.fields("pic4")%>.jpg" vspace=8 > <%end if%> /<%=Itemrs.fields("pic5")%>.jpg','<%=Itemrs.fields("pic5")%>')" onMouseover=borderit(this,'Gainsboro') onMouseout=borderit(this,'White') class="menulines"> <%if Itemrs.fields("pic5") <> "" then%> /<%=Itemrs.fields("pic5")%>.jpg&product_id=<%=v_ProdID%>&color_code_n=<%=v_ColorCode%>'" SRC="Shades/ProductImages/<%=Itemrs.fields("brand_id")%>/<%=Itemrs.fields("pic5")%>.jpg" vspace=8 > <%end if%>
<% set DBConn= nothing set ItemRs= nothing %>