%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% SQLRS = "select * from escritorios order by nome;" SET rs = conexao.execute(sqlrs) %>
| <% if not rs.eof then %>
<% while not rs.eof%>
<%if len(rs("nome")) > 0 then%>
<%=rs("nome")%>
<%end if%>
<%if len(rs("endereco")) > 0 then%> <%=rs("endereco")%> <%end if%> <%if len(rs("complemento")) > 0 then%> / <%=rs("complemento")%> <%end if%> <%if len(rs("bairro")) > 0 then%> - <%=rs("bairro")%> <%end if%> <%if len(rs("cidade")) > 0 then%> - <%=rs("cidade")%> <%end if%> <%if len(rs("ddd")) > 0 then%> Tel.:(<%=rs("ddd")%>) <%if len(rs("telefone")) > 0 then%><%=rs("telefone")%><%end if%> <%end if%> <%if len(rs("ddd")) > 0 and len(rs("fax")) > 0 then%> | Fax.:(<%=rs("ddd")%>) <%=rs("fax")%> <%end if%> <% rs.movenext %> <% wend %> <% end if %> |
||