I'm reading records from the database and
listing them.
I have a field 'aboutu' which is a 'textarea' defined
as 'memo' in the Access database. My alignment is distorted
when I list data from database under the heading :
" Name Email City More details"
Can anyone help me as to how to list data from the database and align the data correctly under the above heading considering the fact that one of the fields is defined as
'memo'.
Thanks
Here is part of the code :
------------------------------------------------------------
<tr>
<td bgcolor="#e5edff" height="20" align="middle">
<b><font size="2" face="arial">Name</font></b>
</td>
<td bgcolor="#e5edff" height="20" align="middle">
<b><font size="2" face="arial">Email</font></b>
</td>
<td bgcolor="#e5edff" height="20" align="middle">
<b><font size="2" face="arial">City </font></b>
</td>
<td bgcolor="#e5edff" height="20" align="middle">
<b><font size="2" face="arial">More details</font></b>
</td>
</tr>
<%
Response.Write "<tr>"&vbcr
Response.Write "<td height=20 align=middle>"&vbcr
Response.Write "<font size=2 face=arial>"&rs1("name"
&"</font>"&vbcr
Response.Write "</td>"&vbcr
Response.Write "<td height=20 align=middle>"&vbcr
Response.Write "<font size=2 face=arial>"&rs1("email"
&"</font>"&vbcr
Response.Write "</td>"&vbcr
Response.Write "<td height=20 align=middle>"&vbcr
Response.Write "<font size=2 face=arial>"&rs1("city"
&"</font>"&vbcr
Response.Write "</td>"&vbcr
Response.Write "<td height=20 align=middle>"&vbcr
Response.Write "<font size=2 face=arial>"&rs1("aboutu"
&"</font>"&vbcr
Response.Write "</td>"&vbcr
Response.Write "</tr>"&vbcr
rs1.MoveNext
Loop
...
listing them.
I have a field 'aboutu' which is a 'textarea' defined
as 'memo' in the Access database. My alignment is distorted
when I list data from database under the heading :
" Name Email City More details"
Can anyone help me as to how to list data from the database and align the data correctly under the above heading considering the fact that one of the fields is defined as
'memo'.
Thanks
Here is part of the code :
------------------------------------------------------------
<tr>
<td bgcolor="#e5edff" height="20" align="middle">
<b><font size="2" face="arial">Name</font></b>
</td>
<td bgcolor="#e5edff" height="20" align="middle">
<b><font size="2" face="arial">Email</font></b>
</td>
<td bgcolor="#e5edff" height="20" align="middle">
<b><font size="2" face="arial">City </font></b>
</td>
<td bgcolor="#e5edff" height="20" align="middle">
<b><font size="2" face="arial">More details</font></b>
</td>
</tr>
<%
Response.Write "<tr>"&vbcr
Response.Write "<td height=20 align=middle>"&vbcr
Response.Write "<font size=2 face=arial>"&rs1("name"
Response.Write "</td>"&vbcr
Response.Write "<td height=20 align=middle>"&vbcr
Response.Write "<font size=2 face=arial>"&rs1("email"
Response.Write "</td>"&vbcr
Response.Write "<td height=20 align=middle>"&vbcr
Response.Write "<font size=2 face=arial>"&rs1("city"
Response.Write "</td>"&vbcr
Response.Write "<td height=20 align=middle>"&vbcr
Response.Write "<font size=2 face=arial>"&rs1("aboutu"
Response.Write "</td>"&vbcr
Response.Write "</tr>"&vbcr
rs1.MoveNext
Loop
...