<% ''''^^^^^^^^^^^^^^^^^^^^ calculation for the Laston Query ^^^^^^^^^^^^ set rs=server.createobject("ADODB.RECORDSET") set rsImg=server.createobject("ADODB.RECORDSET") set rsArt=server.createobject("ADODB.RECORDSET") '#################################################### ' userid=trim(request("test")) ' sql="select * from fz_Affiliate where Affiliate_Id=" & userid 'response.write sql 'response.end rs.open sql,con,1,3 sql2="select ID from fz_images where Affiliate_Id=" & userid rsImg.open sql2,con,1,3 sql3="select * from fz_Articles where Affiliate_Id=" & userid rsArt.open sql3,con,1,3 ' %> FabriZone - Commercial Services
         
 
Dunree, Buncrana, Ireland

<%else %> <% end if %>
 
   


 

<%Aff_email=rs("email")%> <%Aff_email=rs("email2") if Aff_Email<>"" then %> <% end if if not rsArt.EOF then do while not rsArt.EOF %> <%Aff_email=rs("email")%> <% rsArt.MoveNext loop end if %>
Contact: John O'Donnell
Company: Swilly Cleaning Systems
City: Dunree, Buncrana
State/Province: Ireland
Telephone #: 074 9363477
E-Mail: scsystems@eircom.net
Services Offered: Specialists for carpet, upholstery, ceilings, walls, drapery, fiber protection, pet odor removal, area rugs, car interiors, wood, marble, ceramic and tile floors. Water and Smoke damage restoration.
RESIDENTIAL AND COMMERCIAL
 

Affiliate List | Print This Page
  ^ TOP
 




Home | Residential Services | Janitorial Services | Real Estate
Indoor Air Quality | Affiliate List | Useful Tips | Resale Products | Contact Us

© Copyright 2002 FabriZone © Copyright 2002 FabriZone
<% rs.close rsImg.close rsArt.close %>