Come faccio per visualizzare sulle mie pagine ASP campi in valuta Euro prelevati da un database Access?
Esiste una funzione per fare ciò?
premetto che ho inserito e quindi progettato tutta la pagina inserendo "<% @ LANGUAGE = JScript %>".
Se avessi inserito <% @ LANGUAGE = VBscript %> avrei potuto utilizzare FormatNumber, ma adesso come faccio?
Aiutatemi!
questo è il codice che ho usato nella pagina:
<% @ LANGUAGE = JScript %>
<%
__________________________________________________ __________________________
Response.Write("<html>\n")
Response.Write("<head>\n")
Response.Write("<title>Ricerca per categoria</title>\n")
//Response.Write('<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\n')
Response.Write("</head>\n")
Response.Write('<body bgcolor="#FFFFFF" text="#000000">\n')
Response.Write('<div align = "center">\n')
Response.Write('<table border="0" width="100%" cellspacing="0" cellpadding="0"')
Response.Write("<tr>")
Response.Write('<td width="642">')
Response.Write("<td>")
Response.Write('<p align="center">')
Response.Write("Area
")
Response.Write("
")
Response.Write("Clienti</td>")
Response.Write("</tr>")
Response.Write("</table>")
Response.Write("
</p>\n")
Response.Write('
<font face="Verdana,Arial,Helvetica, sans-serif" size="2" color="#660000">\n')
Response.Write("</font></p>\n")
Response.Write('
<font face="Verdana,Arial,Helvetica, sans-serif" size="2">[TORNA INDIETRO]</font>\n')
Response.Write('<font face="Verdana,Arial,Helvetica, sans-serif" size="2">[STAMPA PAGINA]')
Response.Write('<font face="Verdana,Arial,Helvetica, sans-serif" size="2">[INGRANDISCI]</p>')
var Categoria = String(Request.Form("Categoria"))
if (Categoria =="" || Categoria == "undefined") Response.Redirect("categoria.htm")
Response.Write('<p align="center"> [b] <font face="Verdana,Arial,Helvetica, sans-serif" size="4" color="#660000">')
Response.Write(Categoria)
Response.Write('</p>')
Response.Write("</div>\n")
Response.Write("</body>\n")
Response.Write("</html>\n")
var conn = new ActiveXObject("ADODB.Connection")
var stringaDiConnessione = ""
stringaDiConnessione += "Provider=Microsoft.Jet.OLEDB.4.0;"
stringaDiConnessione += "Data Source=" + Server.MapPath("magazzino.mdb")
conn.Open(stringaDiConnessione)
sql = "SELECT * FROM articoli WHERE Categoria LIKE '" + Categoria + "'"
var ris = conn.Execute(sql)
if (ris.EOF) Response.Write("NESSUN ARTICOLO TROVATO")
else while (!ris.EOF){
Response.Write('<table border="1" width="100%" id="table1">')
Response.Write('<tr>')
Response.Write('<td bgcolor="#FF9933">[b] <font face="Verdana,Arial,Helvetica, sans-serif" size="2" color="#660000">Articolo</td>')
Response.Write('<td bgcolor="#FF9933">[b] <font face="Verdana,Arial,Helvetica, sans-serif" size="2" color="#660000">Codice fornitore</td>')
Response.Write('<td bgcolor="#FF9933">[b] <font face="Verdana,Arial,Helvetica, sans-serif" size="2" color="#660000">Codice interno</td>')
Response.Write('<td bgcolor="#FF9933">[b] <font face="Verdana,Arial,Helvetica, sans-serif" size="2" color="#660000">Descrizione</td>')
Response.Write('<td bgcolor="#FF9933">[b] <font face="Verdana,Arial,Helvetica, sans-serif" size="2" color="#660000">Prezzo</td>')
Response.Write('</tr>')
Response.Write('<tr>')
Response.Write('<td width="60" height="60" align="center">')
Response.Write("[img] + ris([/img]")
Response.Write('</td>')
Response.Write('<td width="110" height="60">')
Response.Write('[b] <font face="Verdana,Arial,Helvetica, sans-serif" size="2" color="#660000">\n')
Response.Write(ris("CodiceFornitore"))
Response.Write("</td>")
Response.Write('<td width="110" height="60">')
Response.Write('[b] <font face="Verdana,Arial,Helvetica, sans-serif" size="2" color="#660000">\n')
Response.Write(ris("CodiceInterno"))
Response.Write("</td>")
Response.Write('<td width="350" height="60">')
Response.Write('[b] <font face="Verdana,Arial,Helvetica, sans-serif" size="2" color="#660000">\n')
Response.Write(ris("Descrizione"))
Response.Write('</td>')
Response.Write('<td width="60" height="60" align="right">')
Response.Write('[b] <font face="Verdana,Arial,Helvetica, sans-serif" size="2" color="#660000">\n')
Response.Write(ris("Prezzo"))
Response.Write('</td>')
ris.MoveNext()
}
conn.Close()
%>
</body>
</p>
__________________________________________________ __________________________
</html>
