sto realizzando una rubrica in asp che si connette a dun db access 2000. questo è il codice che ho messo nella pagina che legge i dati:
<table width="550" border="0">
<tr>
<td bgcolor="#0099FF">
<div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">GESTIONE
CALL CENTER</font></div>
</td>
</tr>
</table>
<table width="550" border="1" bordercolor="#0099FF">
<tr>
<td>
<p align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="#0099FF">ELENCO
TELEFONATE</font></p>
</td></tr></table>
<%
Set objconn = Server.CreateObject("ADODB.Connection")
objConn.Open("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " & Server.MapPath("../mdb_database/call_center.mdb"))
Set objRs = Server.CreateObject("ADODB.Recordset")
objrs.open "SELECT * FROM telefonate", objconn
response.write "<table width='1000' border=1 bordercolor='#0099FF'><tr align='left' valign='top' bgcolor='#0099FF'>"
response.write "<td width='107'><font face='Arial, Helvetica, sans-serif' size=2 color='#FFFFFF'>NOME</font></td>"
response.write "<td width='116'><font face='Arial, Helvetica, sans-serif' size=2 color='#FFFFFF'>COGNOME</font></td>"
response.write "<td width='142'><font face='Arial, Helvetica, sans-serif' size=2 color='#FFFFFF'>INDIRIZZO</font></td>"
response.write "<td width=189><font face='Arial, Helvetica, sans-serif' size=2 color='#FFFFFF'>CITTA'</font></td>"
response.write "<td width=136><font face='Arial, Helvetica, sans-serif' size=2 color='#FFFFFF'>TELEFONO</font></td>"
response.write "<td width=90><font face='Arial, Helvetica, sans-serif' size=2 color='#FFFFFF'>FAX</font></td>"
response.write "<td width=190><font face='Arial, Helvetica, sans-serif' size=2 color='#FFFFFF'>EMAIL</font></td>"
response.write "<td width=190><font color='#FFFFFF'>VUOTO</font></td>"
response.write "<td width=190><font color='#FFFFFF'>VUOTO</font></td>"
response.write "</tr>"
Do while NOT objRs.EOF
response.write "<tr align='left' valign='top'>"
response.write "<td width=107><font face='Arial, Helvetica, sans-serif' size=2 & objrs('nome') & </td>"
response.write "<td width=116><font face='Arial, Helvetica, sans-serif' size=2 & objrs('cognome') & </td>"
response.write "<td width=142><font face='Arial, Helvetica, sans-serif' size=2 & objrs('indirizzo') & </td>"
response.write "<td width=189><font face='Arial, Helvetica, sans-serif' size=2 & objrs('citta') & </td>"
response.write "<td width=136><font face='Arial, Helvetica, sans-serif' size=2 & objrs('telefono') & </td>"
response.write "<td width=90><font face='Arial, Helvetica, sans-serif' size=2 & objrs('fax') & </td>"
response.write "<td width=190><font face='Arial, Helvetica, sans-serif' size=2 & objrs('email') & </td>"
response.write "<td width=190><font face='Arial, Helvetica, sans-serif' size=2 & 'cella vuota' & </td>"
response.write "<td width=190><font face='Arial, Helvetica, sans-serif' size=2 & 'cella vuota' & </td>"
objrs.movenext
loop
response.write "</tr></table> "
%>
solo che non visualizza i dati. Help me :-(

Rispondi quotando