ciao io richiamo una pagina dove mi da tutti gli ordini effettuati,ma mi da solo 1 e gli altri no.
ecco il codice:
<%@LANGUAGE="VBSCRIPT"%>
<%option explicit%>
<!--#include file="adovbs.inc"-->
<%dim sql
sql="select IDORDINE,COD_UTENTE,IDARTICOLO,MARCA,MODELLO,QUANTITA,PREZZO,PAGAMENTO from ORDINE"
dim objconn
set objconn=server.CreateObject("adodb.connection")
objconn.open="provider=Microsoft.Jet.Oledb.4.0; data source="&server.MapPath("mdb-database/ottica.mdb")
dim objrs
set objrs=server.CreateObject("adodb.recordset")
objrs.open sql,objconn,3,3
%>
li visualizzo intabella così:
<td bgcolor="#FF0000"><div align="center"><font face="georgia" size="4" color="#FFFFFF"><b>
<%response.Write objrs("IDORDINE")%>
</b></font></div></td>
<td bgcolor="#FF0000"> <div align="center"><font face="georgia" size="4" color="#FFFFFF"><b>
<%response.Write objrs("COD_UTENTE")%>
</b></font></div></td>
<td> <div align="center"><font face="arial" size="2" color="#000000"><b>
<%response.Write objrs("IDARTICOLO")%>
</b></font></div></td>
<td> <div align="center"><font face="georgia" size="2" color="#000000"><b>
<%response.Write objrs("MARCA")%>
</b></font></div></td>
<td bgcolor="#99FF99"> <div align="center"><font face="georgia" size="2" color="#0000FF"><b>
<%response.Write objrs("MODELLO")%>
</b></font></div></td>
<td> <div align="center"><font face="arial" size="2" color="#000000"><b>
<%response.Write objrs("QUANTITA")%>
</b></font></div></td>
<td> <div align="center"><font face="arial" size="2" color="#FF0000"><b>
<%response.Write objrs("PREZZO")%>
</b></font></div></td>
<td> <div align="center"><font face="georgia" size="2" color="#000000"><b>
<%response.Write objrs("PAGAMENTO")%>
</b></font></div></td>
</tr>
<%objrs.movenext
objrs.close
set objrs=nothing
objconn.close
set objconn=nothing
%>
qual'è l'errore?
grazie
