<% dim conn,connstr,dbstr dbstr="data/System.mdb" set conn=CreateObject("adodb.connection") connstr="provider=microsoft.jet.oledb.4.0;data source="& server.MapPath(dbstr) conn.open connstr sqlp="select top 1 * from product where P_Language=2 and P_New=1 order by P_order asc" set rsp=server.CreateObject("adodb.recordset") rsp.open sqlp,conn,1,1 If Not rsp.eof Then P_Content=rsp("P_Wap") Pic=rsp("P_Field3") Pid=rsp("P_id") PSortid=rsp("P_Sortid") End If rsp.close set rsp=nothing sqln="select top 1 * from news where N_Language=2 and N_special=1 order by N_order asc" set rsn=server.CreateObject("adodb.recordset") rsn.open sqln,conn,1,1 If Not rsn.eof Then n_Content=rsn("N_Name") nPic=rsn("N_Pic") nid=rsn("N_id") End If rsn.close set rsn=nothing %> iPad Accessories|Gaming Accessories|MP3 Player|STARMAX ASIA GROUP

 
 
<% i=1 set rs_sort=server.CreateObject("adodb.recordset") rs_sort.open"select * from Product_Sort where PS_Parentid=0 and PS_Dep=2 order by PS_Order asc",conn,1,1 do while not rs_sort.eof set rs2=server.CreateObject("adodb.recordset") rs2.open"select * from Product_Sort where PS_Parentid="&rs_sort("PS_id")&" and PS_Dep=2 order by PS_Order asc",conn,1,1 If rs2.eof then%> <% Else %> <% end if i=i+1 rs_sort.movenext loop %>
<% do while not rs2.eof %>
&Sortid=<%= rs2("PS_Parentid") %>&sub=<%= i %>"><%= rs2("PS_Name") %>
<% rs2.movenext loop %>
 
Download Driver
FAQ Tech Support
 
Introduction
R&D
Quality Control
Factory
 
OEM Service
Online Inquiry
 

leave a message
 
<% sql1="select * from product where P_Language=2 and P_Special=1 order by P_order asc" set rs1=server.CreateObject("adodb.recordset") rs1.open sql1,conn,1,1 If rs1.Eof Then Response.Write("No products yet!") %>
<% n=1 While Not rs1.Eof And n<=rs1.recordcount%> <%n3=1 While Not rs1.Eof And n3<=rs1.recordcount%> <% rs1.MoveNext n3=n3+1 n=n+1 wend%> <%wend%>
<% rs1.close set rs1=nothing %>
 
<% If Pic<>"" Then %><% End If %> <% If P_Content<>"" Then %> <%= P_Content %>
<% End If %>
<% If nPic<>"" and IsNumeric(nid )Then %> <% End If %> <% If n_Content<>"" Then %> <%= n_Content %>
<% End If %>
<% set rs_Page1=server.CreateObject("ADODB.Recordset") rs_Page1.open"select * from page where G_Language=2 and G_id=47",conn,1,1 if not rs_Page1.eof then Name_Page1=rs_Page1("G_Name") Content_Page1=rs_Page1("G_Content") end if rs_Page1.close set rs_Page1=nothing %><%= Content_Page1 %>
 
Copyright © 1999-2009 Starmax Asia Industries Ltd. All Rights Reserved.
ADD: 8/F 8 Bldg. 13 Rd Ying Ren Shi Shi Yan, Bao An District, Shenzhen 518108 PRC
Tel: +86 755 29431246 Fax: +86 755 33922263 E-Mail:export@starmaxasia.com