<% ''''^^^^^^^^^^^^^^^^^^^^ calculation for the Laston Query ^^^^^^^^^^^^ set rs2=server.createobject("ADODB.RECORDSET") ' set rs=server.createobject("ADODB.RECORDSET") '#################################################### sql="select * from fz_Affiliate where email is not null order by countrysort, state, city, company" rs.open sql,con,1,3 ' %> FabriZone - Affiliate List
         
 
 
<%ii=1 Country = "" %> <% do until rs.EOF %> <% id=rs("Affiliate_id") nm=rs("contact") photo=rs("photo_name") 'response.write photo 'response.end if (photo<>"") then fld_nm1=split(photo,"/") fld_nm=fld_nm1(0) end if %> <% if Country <> rs("Country") then Country = rs("Country") ii = 1 %> <% end if %> <% ii=ii+1 rs.movenext loop %>
Canada
State/Province City Company Name
Alberta Calgary Mutch Cleaner Carpet & Upholstery
Newfoundland St. John's

KDW Enterprises Ltd.

Ontario Burgesville Fabrizone Woodstock
Ontario Cochrane & Timmins Raylor Restoration Services
Ontario Toronto Fabrizone Canada Ltd
United States
State/Province City Company Name
Deleware Bethany Beach Schrider Enterprises
International
State/Province City Company Name
Grand Cayman Georgetown Fabrizone Cleaning Systems of Cayman
 



Home | Residential Services | Commercial Services | Prep 'n Sell | Damage Restoration
Indoor Air Quality | Affiliate List | Useful Tips | Resale Products | www.joinfabrizone.com | Members Area | Contact Us

© Copyright 2005 FabriZone