%Response.Buffer=true%>
<% Dim ObjRst,ObjCon,StrSql,StrWhere,StrOrder,StrQry,SubRst
Set ObjRst=Server.CreateObject("ADODB.RecordSet")
Set SubRst=Server.CreateObject("ADODB.RecordSet")
Set ObjCon=Server.CreateObject("ADODB.Connection")
ObjCon.Open DataBase //庫(kù)連接
ObjRst.Open "select * from diy_productlst where corpid="&CorpNo,ObjCon
%>
<%If ObjRst.State=1 Then ObjRst.Close
Dim LngCate
LngCate=Trim(Request("class"))
If Not IsNumeric(LngCate) Or IsEmpty(LngCate) Or IsNUll(LngCate) Then LngCate=505
ObjRst.Open "select title,catimg_s from diy_productlst where corpid="&CorpNo&" and id="&LngCate,ObjCon
If Not ObjRst.Eof Then %>
<%=ObjRst("title")%>
<%SubRst.Open "select title,model,id from diy_products where corpid="&CorpNo&" and category="&LngCate&" order by orderno",ObjCon
Do While Not SubRst.Eof %>