Modificare il file:
\home.asp
<% Set marca = Server.CreateObject("ADODB.Recordset") marca.ActiveConnection = MM_ecommerce_STRING marca.Source = "SELECT DISTINCT Marca FROM Prodotti ORDER BY marca ASC" marca.CursorType = 0 marca.CursorLocation = 2 marca.LockType = 1 marca.Open() marca_numRows = 0 %> <% '************************************************** if N_lista <> "" then Set Prodo = Server.CreateObject("ADODB.Recordset") Prodo.ActiveConnection = MM_ecommerce_STRING Prodo.Source = "SELECT * FROM Prodotti WHERE Marca = '"&N_Lista&"' AND Dispo = 'Y'" Prodo.CursorType = 0 Prodo.CursorLocation = 2 Prodo.LockType = 1 Prodo.Open() Prodo_numRows = 0 END IF '*************************************************************** %> <% Repeat1__numRows = -1 Repeat1__index = 0 marca_numRows = marca_numRows + Repeat1__numRows %> <% Repeat3__numRows = -1 Repeat3__index = 0 Prodo_numRows = Prodo_numRows + Repeat3__numRows %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Liste di Nascite - Martinucci regali e ...</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> <!-- .Stile1 {font-family: verdana} .Stile2 {font-size: x-small} .Stile3 {font-family: verdana; font-size: x-small; } a:link { color: #000000; text-decoration: none; } a:visited { text-decoration: none; color: #000000; } a:hover { text-decoration: none; color: #000000; } a:active { text-decoration: none; color: #000000; } --> </style> </head> <body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0"> <div align="center"> <table height="285" border="0" align="left" cellpadding="0" cellspacing="0" bordercolor="#000000"> <tr> <td height="266" valign="top"><span class="Stile3"><strong> <%if N_Lista <> "" then%> </strong></span> <table width="501" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="599" height="19" bgcolor="#efefef"><div align="center"> <span class="Stile3"><strong> <font face="Verdana"><font color="#0000FF">...:::</font><font color="#FF0000"> </font></font> </strong></span><b><font color="#FF0000"><font face="Verdana" size="2">Clicca sull'immagine per vedere l'articolo in dettaglio </font></font> <font face="Verdana" size="2"><font color="#0000FF">:::...</font></font></b></div></td> </tr> </table> <span class="Stile3"><strong> <%end if%> </strong></span> <table border="0"> <tr> <td> </td> </tr> </table> <%if N_lista <> "" then%> <% numero_riga = 0 While ((Repeat3__numRows <> 0) AND (NOT Prodo.EOF)) %> <% numero_riga = numero_riga+1 ci=(Prodo.Fields.Item("Foto").Value) if ci <> "" then fotina="Admin/ImagesProd/"&(Prodo.Fields.Item("Foto").Value) else fotina="Admin/ImagesProd/nd.jpg" end if descpro=mid((Prodo.Fields.Item("Descrizione").Value),1,300)&"....." art_prezzo = FormatCurrency((Prodo.Fields.Item("Prezzo").Value),2)&" " %><% If (Repeat3__numRows Mod 2) Then col="#f0f0f0" col2="#c0c0c0" Else col="#e5e5e5" col2="#c0c0c0" End IF %> <table width="501" height="51" border="0" class="Stile3" cellspacing="0" cellpadding="0"> <tr> <td width="84" bgcolor="<%=col%>" style="border-left: 1px solid #C0C0C0; border-top: 1px solid #C0C0C0; border-bottom: 0px solid #C0C0C0; "><div align="center"><br> <a href="?az=prod&IDpr=<%=(Prodo.Fields.Item("ID").Value)%>&fcampo=Marca&fcosa=<%=N_lista%>"><img src="<%=fotina%>" alt="" width="70" height="50" border="0"></a><br> <b> <%=art_prezzo%></b><br> </div></td> <td width="6" bgcolor="<%=col%>" style="border-top: 1px solid #C0C0C0; border-bottom: 0px solid #C0C0C0; "><div align="left"> <br> </div></td> <td width="411" valign="top" bgcolor="<%=col%>" style="border-right: 1px solid #C0C0C0; border-top: 1px solid #C0C0C0; border-bottom: 0px solid #C0C0C0; "><div align="left"> <a href="?az=prod&IDpr=<%=(Prodo.Fields.Item("ID").Value)%>&fcampo=Marca&fcosa=&N_lista"><b><%=Prodo("Nome")%></b><br> <br><%=descpro%></a></div></td> </tr> </table> <% Repeat3__index=Repeat3__index+1 Repeat3__numRows=Repeat3__numRows-1 Prodo.MoveNext() Wend %> <table width="501" border="0" cellpadding="0" cellspacing="0" style="border-left: 0px solid #C0C0C0; border-top: 1px solid #C0C0C0; border-bottom: 0px solid #C0C0C0; "> <tr> <td> </td> </tr> </table> <div align="center"> <% If numero_riga = 0 then %> <font face="Verdana" size="5"><b><font color="#0000FF">La Lista è stata completata</font></b><br> </font> <img border="0" src="images/baby.jpg" width="380" height="276"> <%end if%> <%end if%> </div></td></tr> </table> </div> </body> </html>
[
Íàçàä
]