<% dim fid fid=cint(request("fid")) sql="select name,parentid,fid from forum where fid="&fid&" and tid='p'" rs.open sql,conn,1,1 if rs.eof then response.Redirect "index.asp" rs.close %>
 
Category
Cross Reference
 
<% dim cid,ccid cid=cint(request("cid")) ccid=cint(request("ccid")) sql="select * from category where fid=3 and parentid=0 order by orders,cid desc" rs.open sql,conn,1,1 sql="select * from category where cid="&cid&"" rs2.open sql,conn,1,1 if rs2.eof then rs.movefirst cid=rs("cid") end if rs2.close do while not rs.eof %> ">"><%=rs("name")%> <% rs.movenext loop rs.close sql="select * from category where cid="&cid&"" rs.open sql,conn,1,1 'do while not rs.eof sql="select * from category where parentid="&rs("cid")&" order by orders, cid desc" rs2.open sql,conn,1,1 %>
<% do while not rs2.eof response.write " ● "&rs2("name")&"  " rs2.movenext loop rs2.close sql="select * from category where cid="&ccid&" order by orders, cid desc" rs3.open sql,conn,1,1 %>
<%=rs3("item1")%>
<% rs3.close 'rs.movenext 'loop rs.close %>
 
 
 
　　　Position > Products
 
<% dim str,sql2,sql3 sql="select * from product where fid="&fid if ccid<>0 then sql=sql&" and cid="&ccid elseif cid<>0 then sql=sql&" and cid in (select cid from category where parentid="&cid&")" end if if request("key")="item" then sql=sql&" and name like '%"&request("name")&"%'" for j=1 to 8 sql=sql&" and item"&j&" like '%"&request("item"&j)&"%'" next end if sql=sql&" order by cid,orders,pid" if request("key")="keys" then sql="select * from product where fid="&fid&" and (" for j=1 to 9 sql=sql&"key"&j&" like '%"&request("keys")&"%' or " next 'sql=left(sql,len(sql)-4) sql=sql&" name like '%"&request("keys")&"%') order by cid,orders,pid" end if 'sql2=replace(sql,"order by cid,orders,pid","group by item") rs.open sql,conn,1,1 %> <% for j=1 to 8 %> <% next %> <% i=0 do while not rs.eof i=i+1 if i mod 2=0 then temp="#e2f3fd" else temp="#FFFFFF" end if %> <% for j=1 to 8%> <% next %> <% rs.movenext loop rs.close %>
Part Number Supply Voltage(V) Duplex DataRate
(bps)		 ESD Air/
Contact (kV) 		Transceivers
On Bus
 Slew Rate Limited &
Receiver Input Filtering		 Low Power Shutdown Number of Pins Datasheet
                   
&cid=<%=rs("cid")%>&pid=<%=rs("pid")%>" class="blue"><%=rs("name")%><%=rs("item"&j)%> <% if len(trim(rs("pdf")))=0 or isnull(rs("pdf")) then else if rs("pdf_sign")=1 then if session("user")="true" then if cint(session("sign"))=1 then %>    " target="_blank"> * <% else %>     * <% end if else %>     * <% end if elseif cint(rs("pdf_sign"))=0 then %>    " target="_blank">    <% end if end if %>