<% dim ind,cat,lent cat = 3 ind = "001002" lent = 6 %> Trade Details of Brassware,manufacturers and trade directory of Brassware from India <% handicrafts_top "Trade Leads","" %> <% Sql = "select cat_id,pagename from Products_Master where cat_id in (select cat_id from category where index1 like '" & ind & "%')" set rst =server.CreateObject("Adodb.Recordset") rst.Open sql,db,3,2 %>
<% baseprdLink = "http://handicrafts.easy2source.com/products/" If rst.RecordCount > 0 Then %>
Product Categories
<% Do While Not rst.EOF dirSupp = baseprdLink & getFolderName(rst("cat_id")) if cstr(rst("cat_id")) <> cstr(rst("pagename")) then dirSupp = dirSupp & rst("pagename") &".htm" ProductName = GetFieldValue("Pagetitle", "Products_Master", "pagename", rst("pagename")) response.write ""&ProductName&"
" rst.MoveNext Loop %>
<%End If rst.Close %>

<% baseprdLink = "http://handicrafts.easy2source.com/directory/" Set RsSuppCoun = server.CreateObject("Adodb.Recordset") Set RsInnCoun = server.CreateObject("Adodb.Recordset") Sql = "select * from category where index1 like '" & ind & "%' order by category" rst.Open sql,db,3,2 If rst.RecordCount > 0 Then SuppCoun = "Select top 1 Supplier_id from cat where cat_id in (Select cat_id from Category where index1 like '"&ind&"%' )" RsSuppCoun.open SuppCoun,db,3,2 if not RsSuppCoun.eof then %>
Supplier Directory
<% Do While Not rst.EOF InnCoun = "Select Supplier_Id from cat where cat_id = "&rst("Cat_id") RsInnCoun.open InnCoun,db,3,2 if not RsInnCoun.eof then dirProd = baseprdLink & getFolderName(rst("cat_id")) response.write ""&rst("category")&"
" end if RsInnCoun.close rst.MoveNext Loop %>

<% end If RsSuppCoun.close End If %>
Home >> Trade Search >> Metalware >> Brassware :
( Trade Details of Brassware,manufacturers and trade directory of Brassware from India )
Search Result:   0 Buy , 1 Sell and 0 Biz Leads
Narrow your search by selecting a category
All Leads Buy Sell Biz
There is no Trade Lead in this category


| Handicrafts Home | Handicrafts Directory | Handicrafts Products |
--------------------------------------------------------------------------------
Website Development and Search Engine Optimization by : Aditya Infotech
Copyright © 2006 Netlink Solutions (India) Ltd. All rights reserved, including the right to reproduce the contents of this website in whole or in part without prior written permission