Modificare il file:
\home_pin.asp
<% Dim N_Lista N_Lista = request.cookies("Lista") %> <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <TITLE>Visualizza Lista di Nascita</TITLE> <STYLE TYPE="text/css"> <!-- .formhdr { background-image:url('immagini/head-px.bmp'); /*background:blue;*/ color:white; font-family:tahoma; font-size:12 } .formbody{ border:blue thin solid; background:lightyellow; font-family:tahoma; font-size:12 } .formclosebtn{ background-image:url('immagini/close-px.bmp'); width: 21px; height: 21px; border: medium none; cursor: hand } .toolbar{ border-bottom:blue 1px solid; } .datacell{ font-size:12px; } .rowover{ background-color:blue; background-image:url('immagini/head-px.bmp'); color:white } .rowout{ background-color:white; color:black } IMG{ cursor: hand; border: none; } TH{ background-color:lightblue; color: blue; font-size:12px; } DIV{ overflow:scroll; border:blue 1px solid; Height:250px; } body{ font-family: tahoma; font-size: 5pt; color: blue; } --> </STYLE> <SCRIPT Language> function changecolor(nid){ var ee = eval("window." + nid); ee.className="rowover"; return } function changecolorback(nid){ var ee = eval("window." + nid); ee.className="rowout"; return } function close_win(){return window.close();} </SCRIPT> <% dim rs dim cn '*********************************************** ' Aggiunta '*********************************************** dim strDataBasePath ' Percorso del database set rs=server.CreateObject("ADODB.RECORDSET") set cn=server.CreateObject("ADODB.CONNECTION") '******************************************** ' Cambiare il Path del database '******************************************** strDataBasePath = "/mdb-database/E-commerce.mdb" cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath(strDataBasePath) cn.Open '*********************************** ' Apre il database ' rs.Source="Select * from Strutture_Aziendali" <<<-****** (OLD) '*********************************** rs.Source="select * from Prodotti WHERE Marca = '"&N_Lista&"'" rs.ActiveConnection = cn rs.Open ,,0,1 IF not rs.EOF then rs.MoveFirst end if %> </HEAD> <H2 align="center">Lista di Nascita di : <font color="#669999"> <%=n_lista%></font><BODY><BR> </H2> <CENTER> <TABLE CLASS=formbody border=0 cellspacing=0 width="513" height="461"> <TR CLASS=formhdr> <TD colspan=3><B> Martinucci regali e ...</B></TD> <TD align=right> <a title="Torna al menu principale" target="_self" href="mainmenu.html"><img border="0" src="immagini/close-px.bmp" width="21" height="21"></a></TD> </TR> <TR> <TD CLASS=toolbar> </TD> <TD CLASS=toolbar> </TD> <TD CLASS=toolbar> </TD> <TD CLASS=toolbar> </TD> </TR> <TR> <TD colspan=4> <DIV Style="OVERFLOW: scroll; width:614px; height:620px"> <% '************************************** 'Scrive l'intestazione delle colonne '*************************************** Response.Write "<TABLE width=100% cellpadding=2 cellspacing=2>" & chr(13) Response.Write "<TH>---</TH>" & chr(13) Response.Write "<TH>Cod</TH>" & chr(13) Response.Write "<TH> Articolo </TH>" & chr(13) Response.Write "<TH> Descrizione</TH>" & chr(13) Response.Write "<TH> Prezzo </TH>" & chr(13) Response.Write "<TH> Prenotato da </TH>" & chr(13) while not rs.EOF Response.Write "<TR BGCOLOR=white ID=row" & rs.Fields("id") & " onmouseover=changecolor(this.id) onmouseout=changecolorback(this.id)>" & chr(13) Response.Write "<TD CLASS=datacell><A href=# >" & chr(13) Response.Write " " & chr(13) Response.Write "</A></TD>" & chr(13) '************************************** ' campo 1 '************************************** Response.Write "<TD CLASS=datacell>" & chr(13) Response.Write rs.Fields(1) & chr(13) Response.Write "</TD>" & chr(13) '************************************** ' campo 2 '************************************** Response.Write "<TD CLASS=datacell>" & chr(13) Response.Write rs.Fields(2) & chr(13) Response.Write "</TD>" & chr(13) '************************************** ' campo 3 '************************************** Response.Write "<TD CLASS=datacell>" & chr(13) Response.Write rs.Fields(3) & chr(13) Response.Write "</TD>" & chr(13) '************************************** ' campo 4 ////=FormatCurrency((Lista.Fields.Item("Prezzo").Value)) '************************************** Response.Write "<TD CLASS=datacell>" & chr(13) Response.Write FormatCurrency(rs.Fields(4)) & chr(13) Response.Write "</TD>" & chr(13) '************************************** ' campo 5 '************************************** Response.Write "<TD CLASS=datacell>" & chr(13) Response.Write rs.Fields(9) & chr(13) Response.Write "</TD>" & chr(13) Response.Write "</TR>" & chr(13) rs.MoveNext wend Response.Write "</TABLE>" %> </DIV> </TD></TR> </TABLE> </CENTER> </BODY> </HTML>
[
Íàçàä
]