[wdvltalk] Filling 2 columns

[jac]

yes oh yes oh yes oh YES! it works! Thanks for your help everyone - as with
so many other things I learned here, I couldn't have done it without the
help of the list.

next hurdle :o) now it's displaying the contents of the DB but in a HTML
table of two columns the output is skipping the second, leaving me with a
table with only the lefthand side populated. How do I get it to fill both
sides?

This is what I've got so far:

<snip....>

<table border="0" cellspacing="1" cellpadding="2" width="98%"
align="center">
  <tr align="center">
    <%
Dim objConn ,sSQL,objRS
 Set objConn = Server.CreateObject("ADODB.Connection")
 objConn.ConnectionString = "DSN=liam"
 objConn.Open
 sSQL= "SELECT * FROM residential"
 Set objRS=objConn.Execute(sSQL)

do until objRS.EOF
%>
    <td valign="top" class="prop" width="10%" align="left"><img
src="prop/<%=objRS("pic")%>" width="180" alt="Liam Mullins
Auctioneers"/></td>
    <td valign="top" class="prop" align="left"
width="40%"><b><%=objRS("address")%></b><br>
      <b><%=objRS("town")%></b><br>
      <b><%=objRS("county")%></b><br>
      Description: <%=objRS("desc")%><br>
      Price Guide: &euro; <%=objRS("price")%> <br>
   </td>
    <td valign="top" class="prop" width="10%" align="left"><img
src="<%=objRS("pic")%>" width="180" alt="Liam Mullins Auctioneers"/></td>
    <td valign="top" class="prop" width="40%"
align="left"><b><%=objRS("address")%></b><br>
      <b><%=objRS("town")%></b><br>
      <b><%=objRS("county")%></b><br>
      Description: <%=objRS("desc")%><br>
      <b>Price Guide: &euro; <%=objRS("price")%></b><br>
    </td></tr>
    <%objRS.MoveNext
        loop %>

   <%
   objRS.close
   objConn.close

   Set objRS=nothing
   Set objConn=nothing

   %>
</table>

thanks in advance :o)

jac.



____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] 
       Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
    http://wdvl.internet.com/WDVL/Forum/#sub

________________  http://www.wdvl.com  _______________________

You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]