%
''''^^^^^^^^^^^^^^^^^^^^ 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
|
|
| |
 |
 |
Toronto,
Ontario |
 |
|
| |
|
|
<%else %>
|
<% end if %>
|
| Contact: |
David Collier |
| Company: |
FabriZone Cleaning Systems |
| City: |
Toronto |
| State/Province: |
Ontario |
| Telephone
#: |
(416) 201-1010
888 781-1123 |
| Fax:
|
(905) 602-7821 |
|
E-Mail: |
<%Aff_email=rs("email")%>
cleaning@fabrizone.com |
<%Aff_email=rs("email2")
if Aff_Email<>"" then
%>
| Services
Offered: |
People are more inclined to maintain their investments
than replace them. We are happy to have chosen FabriZone for
our business and highly recommend FabriZone as a sure investment. |
<%
end if
if not rsArt.EOF then
do while not rsArt.EOF
%>
|
<%Aff_email=rs("email")%>
|
<%
rsArt.MoveNext
loop
end if
%>
Affiliate
List | Print
This Page |
|
<%
rs.close
rsImg.close
rsArt.close
%>