<%@LANGUAGE=VBScript%> HBA Products <% dim cnn3,rsn3 set cnn3=createobject("Adodb.Connection") cnn3.open strcon if request.QueryString("gid")<>"" then qry = "SELECT * FROM product WHERE prodid="& request.QueryString("gid") set rs = cnn3.execute(qry) end if %>
 
<%response.Write(rs("prodname"))%>
<% strimg="" if (rs("prodpic"))<>"" then strimg=server.MapPath(rs("prodpic")) elseif rs("prodpicrev")<>"" then strimg=server.MapPath(rs("prodpicrev")) end if %>
 
 
<%response.Write(rs("company"))%>
<%=replace(rs("proddescp"),vbcrlf,"
")%>
 
<% if strimg<>"" then b=ImageResize(strimg,231,223) x=instr(1,strimg,"admin\documents\") if x<>0 then x=x-1 a=Right(strimg,len(strimg)-x) end if %> <%else%> <%end if%> <% if rs("offer")<>0 then if isnull(rs("offer"))=false then %> <%end if end if set rs=Nothing set cnn3=Nothing %>
border=1/>
 
<%response.Write("Special Offer " & rs("offer") & " %" )%>