Ho necessità di costruire una pagina "notizie" con due righe e due colonne, in cui inserire il titolo, un'immagine, un testo-notizia, il link ad un sito esterno. Tutti questi dati li pesco da un database.
Ho costruito il recordset, ma non so come inserire un ciclo per avere le notizie in due righe/due colonne.
posto il codice:

<%@LANGUAGE="VBSCRIPT"%>

<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_connNotizie1_STRING
Recordset1.Source = "SELECT ArticleName, ArticleImageURL, ArticleLinkURL, ArticleActive, ArticleData FROM tblQNArticles ORDER BY ArticleData ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<table width="100%" border="0" class="tabledot">
<tr>
<td width="10"></td>
<td width="200">
<div align="center">" target="_blank">[img]<%=(Recordset1.Fields.Item([/img]" border="0" alt="<%=(Recordset1.Fields.Item("ArticleName").Val ue)%>"></div>
</td>
<td width="40"></td>
<td width="200">
<div align="center">[img]../images/immagine2.jpg[/img]</div>
</td>
<td width="10"></td>
</tr>
<tr>
<td width="10"></td>
<td class="testo" width="200" valign="top"> <%=(Recordset1.Fields.Item("ArticleData").Value) %>[" class="linkregular" target="_blank">more]</td>
<td width="40"></td>
<td class="testo" width="200" valign="top">Notizia 2[more]
</td>
<td width="10"></td>
</tr>
<tr>
<td width="10" height="10"></td>
<td width="200" height="10"></td>
<td width="40" height="10"></td>
<td width="200" height="10"></td>
<td width="10" height="10"></td>
</tr>
<tr>
<td width="10"></td>
<td width="200">
<div align="center">[img]../images/immagine3.jpg[/img]</div>
</td>
<td width="40"></td>
<td width="200">
<div align="center">[img]../images/immagine4.jpg[/img]</div>
</td>
<td width="10"></td>
</tr>
<tr>
<td width="10"></td>
<td width="200">Notizia 3[more]
</td>
<td width="40"></td>
<td width="200">Notizia 4[more]
</td>
<td width="10"></td>
</tr>
</table>
<%
Recordset1.Close()
%>
Qualche suggerimento? Grazie