|
產品中心 |
<% ClassID=request("ID")
if ClassID="" or isnull(ClassID) then
sq="select * from Product order by id desc"
else
sq="select * from Product where ProductNumberID='"&ClassID&"'"
end if %>
<% set re=server.CreateObject("adodb.recordset")
re.open sq,conn,1,1
if re.eof then
response.write "產品正在添加中....."
else
set recc=server.CreateObject("adodb.recordset")
sql="select * from Class where NumberID='"&re("class")&"'"
recc.open sql,conn,1,1
if not recc.eof or not recc.bof then
prolistclass=recc("class")
end if
recc.close
set recc=nothing
%>
<%
end if
re.close
set re=nothing
%> |
|