:master:
<%
nomeattivita = replace(request.form("nomeattivita"),"'","''")
SQL="SELECT * FROM attivita WHERE tipologia='" & Request( "tipologia" ) & "' or nomeattivita='" & nomeattivita & "' or lettera='" & Request( "lettera" ) & "' ORDER BY tipologia, nomeattivita asc "
Set rs=Server.CreateObject("ADODB.Recordset")
Set rs=Conn.Execute(SQL)
'response.write (SQL)
while not rs.eof

%>


<table width="322" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#CCCCCC">
<td colspan="2">
<div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><%=rs("tipologia")%></font></div>
</td>
</tr>
<tr>
<td width="142"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Nome attivit&agrave;: </font></td>
<td width="180"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><%=rs("nomeattivita")%></font></td>
</tr>
<tr>
<td width="142"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Titolare:</font></td>
<td width="180"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><%=rs("titolare")%></font></td>
</tr>
<tr>
<td width="142"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Via:</font></td>
<td width="180"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><%=rs("via")%></font></td>
</tr>
<tr>
<td width="142"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Citt&agrave;:</font></td>
Helvetica, sans-serif" size="2"><%=rs("citta")%></font></td>
</tr>
<tr>
<td width="142"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Telefono1:</font></td>
<td width="180"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><%=rs("telefono1")%></font></td>
</tr>
<tr>
<td width="142"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Telefono2:</font></td>
<td width="180"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><%=rs("telefono2")%></font></td>
</tr>
<tr>
<td width="142" height="19"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">E-mail:</font></td>
<td width="180" height="19"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><%=rs("email")%></font></td>
</tr>
<tr>
<td width="142"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Sito internet: </font></td>
<td width="180"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">" target="_blank"><%=rs("sito")%></font></td>
</tr>
<tr>
<td colspan="2">
<div align="left"></div>
</td>
</tr>
</table>
<%rs.movenext
wend%>