<%@ CodePage=65001 %> <% call connect() %> <% id=Replace(Trim(Request.QueryString("id")),"'","''") if not isnumeric(id) then response.Redirect("index.asp") end if '******************************************** 'FOR CATEGORY TITLE '******************************************** sql = "SELECT C.id as CategoryID,C.categoryname FROM product_category C , products P where C.id=P.categoryid and P.categoryid<>4 and P.id=" & id set rs_category=cnn.execute(sql) if not rs_category.eof then categoryname=StrReplace(rs_category("categoryname")) CategoryId=rs_category("categoryname") end if set rs_category=nothing '******************************************** 'FOR PRODUCT DETAILS '******************************************** sql = "SELECT * FROM products where id="& id set rs_product=cnn.execute(sql) %>

<%= categoryname %> " /> <% If StrReplace(rs_product("preview_pdf_filename"))<>"" Then %>" target="_blank">Click here to view the pdf version<% End If %> <%= StrReplace(rs_product("title")) %> <%if trim(rs_product("description"))<>"" then Response.Write(StrReplace(Replace(rs_product("description"),"’","'"))) %> <% If StrReplace(rs_product("UPC"))<>"" and rs_product("categoryid")<>4 Then %> UPC: <%= StrReplace(rs_product("UPC")) %> <%end if%> <% If StrReplace(rs_product("Type"))<>"" Then %> <%= StrReplace(rs_product("Type")) %> <%end if%> Price: $<%= StrReplace(rs_product("price")) %> <% If StrReplace(rs_product("footer_hyperlink_title"))<>"" Then %> " class="bluelinks"><%= StrReplace(rs_product("footer_hyperlink_title")) %> <% End If %> <% If StrReplace(rs_product("footer_hyperlink_title2"))<>"" Then %> " class="bluelinks"><%= StrReplace(rs_product("footer_hyperlink_title2")) %> <% End If %> <% If StrReplace(rs_product("footer_hyperlink_title3"))<>"" Then %> " class="bluelinks"><%= StrReplace(rs_product("footer_hyperlink_title3")) %> <% End If %> <% If StrReplace(rs_product("footer_hyperlink_title4"))<>"" Then %> " class="bluelinks"><%= StrReplace(rs_product("footer_hyperlink_title4")) %> <% End If %> <% If StrReplace(rs_product("footer_hyperlink_title5"))<>"" Then %> " class="bluelinks"><%= StrReplace(rs_product("footer_hyperlink_title5")) %> <% End If %> <% If StrReplace(rs_product("footer_hyperlink_title6"))<>"" Then %> " class="bluelinks"><%= StrReplace(rs_product("footer_hyperlink_title6")) %> <% End If %> <% If StrReplace(rs_product("footer_hyperlink_title7"))<>"" Then %> " class="bluelinks"><%= StrReplace(rs_product("footer_hyperlink_title7")) %> <% End If %> <% If StrReplace(rs_product("footer_hyperlink_title8"))<>"" Then %> " class="bluelinks"><%= StrReplace(rs_product("footer_hyperlink_title8")) %> <% End If %> <% If StrReplace(rs_product("footer_hyperlink_title9"))<>"" Then %> " class="bluelinks"><%= StrReplace(rs_product("footer_hyperlink_title9")) %> <% End If %> <% If StrReplace(rs_product("footer_hyperlink_title10"))<>"" Then %> " class="bluelinks"><%= StrReplace(rs_product("footer_hyperlink_title10")) %> <% End If %> <%If CategoryId<>4 Then %> "> <%else%> Not available for sale <%end if%>