<tr>
<td align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%" align="center">
<tr>
<td width="27%" valign="middle" align="center" bordercolor="#808080" colspan="6"><font face="Tahoma" color="#afeeee" size="3">IMPEGNI</font></td>
</tr>
<tr>
<td width="5%" valign="middle" align="center" bordercolor="#808080"><p align="center"></td>
<td width="3%" valign="middle" align="center" bordercolor="#808080"><font size="1" face="Tahoma" color="#fff8dc">DATA</font></td>
<td width="2%" valign="middle" align="center" bordercolor="#808080"><font size="1" face="Tahoma" color="#fff8dc">ORA</font></td>
<td width="7%" valign="middle" align="center" bordercolor="#808080"><font face="Tahoma" color="#fff8dc" size="1">OPERATORE</font></td>
<td width="5%" valign="middle" align="center"><font face="Tahoma" color="#fff8dc" size="1"></font></td>
<td width="5%" valign="middle" align="center"><font size="1" face="Tahoma" color="#fff8dc">CONFERMA</font></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%" align="center">
<tr>
<td align="center">
<%
strSQL = "SELECT * FROM impegni WHERE " &_
"operatorescadenza Like '%" & Trim(session("operatorescadenza")) & "%' AND datascadenza Like '%" & Trim(session("datascadenza")) & "%' ORDER BY datascadenza ASC, orainizio ASC"
Set objrs = Server.CreateObject("ADODB.Recordset")
objrs.cursorlocation = 3
objrs.Open strSQL, cn
%>
<table border="0" cellpadding="0" cellspacing="0" width="100%" align="center">
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" width="100%" align="center">
<% While NOT objrs.EOF %>
<tr>
<td width="5%" align="center"><p align="center">" target="_self"><font face="Tahoma" size="2">[img]edit.gif[/img]</font></p></td>
<td width="3%" align="center"><font face="Tahoma" color="#FFFFFF" size="1"><%=objrs("datascadenza")%></font></td>
<td width="2%" align="center"><font face="Tahoma" color="#FFFFFF" size="1"><%=objrs("orainizio")%></font></td>
<td width="7%" align="center"><font face="Tahoma" color="#FFFFFF" size="1"><%=objrs("operatorescadenza")%></font></td>
<td width="5%" align="center"><font face="Tahoma" color="#FFFFFF" size="1"></font></td>
<td width="5%" align="center"></td>
</tr>
<%objrs.MoveNext : Wend%>
</table>
</td>
</tr>
</table>
<%
'Chiusura recordset
objrs.Close
Set objrs = Nothing
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>

Rispondi quotando

