What code do I use to make this show in a table?

Do While Not rsNews.EOF
    Response.Write ("<br>")
    Response.Write (rsNews("NewsInfo"))
    Response.Write ("<br>")
    Response.Write ("")
    rsNews.MoveNext
Loop

Thanks for your help!

Response.Write ("<table>")

Do While Not rsNews.EOF
    Response.Write ("<tr>")
    Response.Write ("<td>")
    Response.Write ("<br>")
    Response.Write (rsNews("NewsInfo"))
    Response.Write ("<br>")
    Response.Write ("")
    Response.Write ("</td>")
    Response.Write ("</tr>")

    rsNews.MoveNext
Loop

Response.Write ("</table">)

---------------------------------------------

Since you are putting this in a table you don't really need the break rules but it will add more space. You can also put the horizontal rule in it's own row if you want by modifying the code a little.

Hope this helps.

J

That does help. Where would I put a second one...ex: NewsDate, or something...to show up on the next row or column?

You need to specify each column you want to show from the row.

    Response.Write ("<td>" & rsNews("NewsInfo") & "</td>")
    Response.Write ("<td>" & rsNews("NewsDate") & "</td>")
    Response.Write ("<td>" & rsNews("<another column>") & "</td>")

Peter
------------------------------------------------------
Work smarter, not harder.