eccolo!!!!!

'connessiona al DB
Call openConn1(conn,rs,rs1)

sql= "select * from articoli where id_articolo ="&id_articolo
RS.open sql,conn,3,3

%>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="500" id="AutoNumber2">
<tr>
<td width="100%" height="4"></td>
</tr>
</table>

</center>
</div>
<div align="center">
<center>

<table border="1" height="110" class="articolo1" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#003300" width="500" id="AutoNumber3">


<%
rs("descrizione") = Replace(rs("descrizione"), "''","'")
'rs("foto_grande") = replace(rs("foto_grande"), "''", "'")
%>


<tr>

<%if rs("foto_piccola") <> "" then%>
<td width="200" style="border-left:medium none #111111; border-top:medium none #111111; border-right-style:none; border-right-width:medium; border-bottom-style:none; border-bottom-width:medium">
<p align="center">
<a href="javascriptopup(escape('<%=replace(rs("descrizione"),"'", "\'") %>'),'<%=rs("foto_grande") %>');">
[img]../../images/gif/<%=rs([/img]"></a></td>

<%end if%>
<td width="340" style="border-style:none; border-width:medium; ">
<%'=rs("descrizione")%>
<%Response.Write Replace(rs("descrizione"), "''","'") %>
<p align="center">
</td>

</table>

<%
rs.close

sql= "select * from associazione_essenze where id_articolo ="&id_articolo
rs.open sql,conn,3,3

if not rs.eof then %>

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="500" id="AutoNumber2">
<tr>
<td width="100%" height="4" style="border-bottom-style: solid; border-bottom-width: 1px"></td>
</tr>
<tr>
<td width="100%" height="4" style="border-style: solid; border-width: 1px">
<p align="center"><font size="1">Essenze disponibili</font></p>

<table border="0" width="100%" id="table1">
<%do while not rs.eof%>

<%sql1= "select * from essenze where id ="&rs("id_essenza")
rs1.open sql1,conn,3,3%>

<tr>
<td width="206"><font size="1"><%=rs1("nome_essenza")%></font></td>

<%if rs1("file") <> "" then%>
<td>.zip"><font size="1"><%=rs1("file")%></font></td>
<%end if%>
</tr>
<%
rs1.close
rs.movenext
loop%>
</table>
</td>
</tr>
</table>

<%end if%>


<font size="1">Torna alla pagina precedente</font></p>
</div>
</BODY></HTML>