ProductID = Request.QueryString("pid")
if ProductID = "" then
Response.Write "参数传输错误!"
Response.End
end if
set rs1= server.CreateObject("ADODB.RECORDSET")
set rs2 = server.CreateObject("ADODB.RECORDSET")
%>
预览产品信息
sqlstr1="select p.*,c.catalogname from ys_product2 as p inner join ys_product2_catalog as c on p.catalogid=c.catalogid "
sqlstr1= sqlstr1 & " WHERE ID = " & ProductID
rs1.Open sqlstr1,conn,1,1
sqlstr2= "SELECT Field1,Field2,Field3,Field4 from ys_product2_catalog where catalogid="&rs1("catalogid")
rs2.Open sqlstr2,conn,1,1
if rs1.EOF or rs1.EOF then
Response.Write "数据库错误,或没有该产品"
else
sqlstr = "UPDATE ys_product2 SET hitCount=hitCount+1 WHERE ID=" &ProductID
conn.Execute sqlstr
%>
【】
【】
【】
【】
产品简介
详细图片
关闭