%Response.Buffer=true%>
<% Dim ObjRst,ObjCon,StrSql,StrWhere,StrOrder,StrQry,SubRst
Set ObjRst=Server.CreateObject("ADODB.RecordSet")
Set ObjCon=Server.CreateObject("ADODB.Connection")
ObjCon.Open DataBase //庫連接
Dim LngId
LngId=Trim(Request("findid"))
If Not IsNumeric(LngId) Or IsEmpty(LngId) Or IsNUll(LngId) Then LngId=0
Dim StrTitle,StrModel,StrDetail,StrImg,StrCatetitle
ObjRst.Open "select p.title ptitle,l.title ltitle,model,mainimg,p.detail pdetail,img10 from diy_productlst l,diy_products p where p.category=l.id and p.corpid="&CorpNo&" and p.id="&LngId,ObjCon
If Not ObjRst.Eof Then
StrTitle=ObjRst("ptitle")
StrModel=ObjRst("model")
StrDetail=ObjRst("pdetail")
StrImg=ObjRst("mainimg")
StrCatetitle=ObjRst("ltitle")
StrParaImg=ObjRst("img10")
Else
ObjRst.Close
Set ObjRst=Nothing
ObjCon.Close
Set ObjCon=Nothing
Response.Redirect "default.asp"
End If
ObjRst.Close
%>