Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Textarea : How to correctly list data from database 1

Status
Not open for further replies.

vias

Programmer
Apr 25, 2000
54
GB
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=&quot;#e5edff&quot; height=&quot;20&quot; align=&quot;middle&quot;>
<b><font size=&quot;2&quot; face=&quot;arial&quot;>Name</font></b>
</td>

<td bgcolor=&quot;#e5edff&quot; height=&quot;20&quot; align=&quot;middle&quot;>
<b><font size=&quot;2&quot; face=&quot;arial&quot;>Email</font></b>
</td>


<td bgcolor=&quot;#e5edff&quot; height=&quot;20&quot; align=&quot;middle&quot;>
<b><font size=&quot;2&quot; face=&quot;arial&quot;>City </font></b>
</td>

<td bgcolor=&quot;#e5edff&quot; height=&quot;20&quot; align=&quot;middle&quot;>
<b><font size=&quot;2&quot; face=&quot;arial&quot;>More details</font></b>
</td>
</tr>

<%
Response.Write &quot;<tr>&quot;&vbcr
Response.Write &quot;<td height=20 align=middle>&quot;&vbcr
Response.Write &quot;<font size=2 face=arial>&quot;&rs1(&quot;name&quot;)&&quot;</font>&quot;&vbcr
Response.Write &quot;</td>&quot;&vbcr

Response.Write &quot;<td height=20 align=middle>&quot;&vbcr
Response.Write &quot;<font size=2 face=arial>&quot;&rs1(&quot;email&quot;)&&quot;</font>&quot;&vbcr
Response.Write &quot;</td>&quot;&vbcr

Response.Write &quot;<td height=20 align=middle>&quot;&vbcr
Response.Write &quot;<font size=2 face=arial>&quot;&rs1(&quot;city&quot;)&&quot;</font>&quot;&vbcr
Response.Write &quot;</td>&quot;&vbcr

Response.Write &quot;<td height=20 align=middle>&quot;&vbcr
Response.Write &quot;<font size=2 face=arial>&quot;&rs1(&quot;aboutu&quot;)&&quot;</font>&quot;&vbcr
Response.Write &quot;</td>&quot;&vbcr

Response.Write &quot;</tr>&quot;&vbcr

rs1.MoveNext
Loop
...
 
Not exactly sure what you mean by distorted.
Code:
<%
If not isnull(rs1(&quot;Aboutu&quot;)) then
     Aboutu = replace(rs1(&quot;Aboutu&quot;),vbcrlf,&quot;<br>&quot;)
Else
     Aboutu = &quot;[ignore] [/ignore]&quot;
End if
Response.Write &quot;<td  height=20 align=left>&quot;&vbcr
   Response.Write &quot;<font size=2 face=arial>&quot;& aboutu & &quot;</font>&quot;&vbcr
   Response.Write &quot;</td>&quot;&vbcr
%>
This will put back any line breaks if they exist.
BTW, in the else section of the IF/End IF a non-breaking space is supposed to be between those quotes. For whatever reason it won't let me type that in. & n b s p;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top