|
| |
|
|
midosm
Posts: 3
Joined: 2/25/2004
Status: offline
 |
Access Memo Format - 2/25/2004 17:55:25
When i add content to the memo field with HTML tags it will not format correctly:
me<br><br>you
Shows like above and not like:
me
you
any ideas?
|
|
|
|
BeTheBall
Posts: 6356
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Access Memo Format - 2/25/2004 18:53:05
How are you displaying the data? In other words what is your html to display the memo field on your page?
By the way, welcome to the forum.
You may want to read this post from today and see if it helps you any.
http://www.frontpagewebmaster.com/m-184834/tm.htm
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
midosm
Posts: 3
Joined: 2/25/2004
Status: offline
|
RE: Access Memo Format - 2/25/2004 18:58:47
Here is the code i am using:
<%
Server.ScriptTimeout = 180
Set rs = Server.CreateObject("ADODB.RecordSet")
q = "SELECT * FROM network WHERE id=" & Request("id")
rs.Open q, "DSN=teamans;"
%>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title></title>
</head>
<body>
<table border="0" id="table1" align="left" cellpadding="4" bordercolor="#000000" bordercolorlight="#000000" bordercolordark="#000000" cellspacing="0">
<tr>
<td>
<font size="2" face="Tahoma">
<img border="0" src="images/<%=rs("image")%>" align="left" vspace="3"></font></td>
</tr>
</table>
<p>
<font size="2" face="Tahoma">
<%=rs("bio")%></font></p>
</body>
<%rs.close%>
<%set rs=nothing%>
| |
|
|
|
BeTheBall
Posts: 6356
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Access Memo Format - 2/25/2004 20:20:46
quote:
When i add content to the memo field with HTML tags it will not format correctly:
me<br><br>you
Shows like above and not like:
me
you
Are you saying the database field contains HTML? In other words, are the <br> tags already in the db?
If so, my only suggestion is to first write the field value to a variable and then display the variable:
<%
MyVar=rs("bio")
Response.write MyVar
%>
If the db field does not contain HTML and you are trying to convert carriage returns to <br>, then try something like this:
Try changing:
<%=rs("bio")%>
to
<%=Replace(rs("bio"),Chr(13),"<br>")%>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
midosm
Posts: 3
Joined: 2/25/2004
Status: offline
|
RE: Access Memo Format - 2/25/2004 20:25:15
<%=Replace(rs("bio"),Chr(13),"<br>")%> did the trick! Thanks.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
