<%@LANGUAGE="VBSCRIPT"%> <% Dim ultime__MMColParam ultime__MMColParam = "vendita" If (Request("MM_EmptyValue") <> "") Then ultime__MMColParam = Request("MM_EmptyValue") End If %> <% Dim ultime Dim ultime_cmd Dim ultime_numRows Set ultime_cmd = Server.CreateObject ("ADODB.Command") ultime_cmd.ActiveConnection = MM_centroaffitti_STRING ultime_cmd.CommandText = "SELECT * FROM case WHERE tipologia = ? AND attiva = 's' ORDER BY ordine ASC" ultime_cmd.Prepared = true ultime_cmd.Parameters.Append ultime_cmd.CreateParameter("param1", 200, 1, 255, ultime__MMColParam) ' adVarChar Set ultime = ultime_cmd.Execute ultime_numRows = 0 %> <% Dim HLooper1__numRows HLooper1__numRows = 3 Dim HLooper1__index HLooper1__index = 0 ultime_numRows = ultime_numRows + HLooper1__numRows %> <% startrw = 0 endrw = HLooper1__index numberColumns = 3 numrows = 1 while((numrows <> 0) AND (Not ultime.EOF)) startrw = endrw + 1 endrw = endrw + numberColumns %> <% While ((startrw <= endrw) AND (Not ultime.EOF)) %> <% startrw = startrw + 1 ultime.MoveNext() Wend %> <% numrows=numrows-1 Wend %>
<%=(ultime.Fields.Item("nome").Value)%>
&tipologia=in vendita&lingua=ita" target="_top">/m_<%=(ultime.Fields.Item("nome file immagine").Value)%>.jpg" width="180" height="130" hspace="5" border="0" />
<% ultime.Close() Set ultime = Nothing %>