<% dim userlevel If Session("UserLevel") = "" Then userlevel = "price_group4" else userlevel = Session("UserLevel") End If %> Product Detail - www.eCOX.com.hk <% On Error Resume Next Dim GetModel GetModel = request("model") strDSN = "driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("db2.mdb") & ";uid=;pwd=" strSQL = "Select a.category_id, a.category_desc_c, b.group_id, b.group_desc_c, c.subgroup_id, c.subgroup_desc_c, d.brand_desc_c, " strSQL = strSQL + "e.barcode, e.model_no, e.end_user_price,e.price_group1, e.price_group2, e.price_group3, e.price_group4, e.price_group5,e.keep_in_stock, " strSQL = strSQL + "e.spec1, e.spec2, e.spec3, e.spec4, e.out_pack1, e.out_pack2, e.out_pack3, e.outpack4, e.photo " strSQL = strSQL + " From i_cox_category a, i_cox_group b, i_cox_subgroup c, i_cox_brand d, i_cox_goods e " strSQL = strSQL + " Where e.category_id = a.category_id And e.group_id = b.group_id And e.subgroup_id = c.subgroup_id " strSQL = strSQL + " And e.brand_id = d.brand_id And e.model_no = '" &GetModel & "'" Set rs = Server.CreateObject("ADODB.RecordSet") rs.Open strSQL, strDSN %>
主頁 HomePage eCOX eCatalog 產品目錄 SALE  Installation 產品安裝價目 Order & Payment Methods 訂購付款 Contact Us 主頁 HomePage Contact Us ecox 電器資訊網 Electronic Depot 訂購產品/付款 Order & Payment Methods 訂購產品/付款 Order & Payment Methods 訂購產品/付款 Order & Payment Methods eCOX Forum 資訊討論區 保養及查詢代理 Warranties 產品安裝價目 Installation 訂購產品/付款 Order & Payment Methods 公司簡介/客戶 eCOX's customers 陳列室地址 Showroom Address 主頁 HomePage Contact Us ecox 電器資訊網 Electronic Depot 陳列室地址 Showroom Address eCOX experience eCOX 新體驗 eCOX Announcement eCOX 通告  Health Products 健康生活產品 Lighting Products eCatalog 燈光產品  產品目錄 Ventilating Products eCatalog 通風設備 產品目錄 Heating Products eCatalog 電熱產品 產品目錄 Kitchen Appliances eCatalog 家廚用品 產品目錄 Home Appliances eCatalog 大型家電 產品目錄 Audio & Visual  影音器材 Health Products 健康生活產品 Lighting Products 燈光產品 Ventilating Products 通風設備 Heating Products 電熱產品 Kitchen Appliances 家廚用品 Large Appliances 大型家電 Audio & Visual 影音器材 產品目錄 eCatalog 價格表 Price List eCOX Inquiry Form 查詢表格 eCOX Forum 資訊討論區 保養及查詢代理 Warranties 產品安裝價目 Installation 訂購產品/付款 Order & Payment Methods Company Profile 公司簡介 陳列室地址 Showroom Address 主頁 HomePage Contact Us ecox 電器資訊網 Electronic Depot
eCOX Store
eCOX Store
<%Response.Write rs("category_desc_c")%> > "><%Response.Write rs("group_desc_c")%> > <%Response.Write rs("subgroup_desc_c")%>

<%Response.Write rs("subgroup_desc_c")%>

<% End If %>
<% If Trim(rs("photo")) <> "" Then %> ">

<%Response.Write rs("brand_desc_c")%> - <%Response.Write rs("subgroup_desc_c")%>

型號 <%Response.Write rs("model_no")%>

<% If userlevel = "price_group4" Then Response.Write "現金價" elseif userlevel = "price_group2" Then Response.Write "批發價" elseif userlevel = "price_group1" Then elseif userlevel = "price_group5" Then Response.Write "批發價" End if %> : $ <% If userlevel = "price_group4" Then Response.Write rs("price_group3") Response.Write rs("/") Response.Write rs("outpack4") elseif userlevel = "price_group2" Then Response.Write rs("price_group2") Response.Write rs("/") Response.Write rs("outpack2") elseif userlevel = "price_group5" Then Response.Write rs("price_group5") Response.Write rs("/") Response.Write rs("outpack1") elseif userlevel = "price_group1" Then Response.Write rs("price_group1") Response.Write rs("/") Response.Write rs("outpack1") End if %>

   
 

產品資料

<% If Trim(rs("spec1")) <> "" Then %>
  • <%Response.Write rs("spec1")%>

  • <% End If %> <% If Trim(rs("spec2")) <> "" Then %>
  • <%Response.Write rs("spec2")%>

  • <% End If %> <% If Trim(rs("spec3")) <> "" Then %>
  • <%Response.Write rs("spec3")%>

  • <% End If %> <% If Trim(rs("spec4")) <> "" Then %>
  • <%Response.Write rs("spec4")%>

  • <% End If %>
   
   
 
<% rs.Close %>