Help with reading HTML code from a database

[Neilbaker86]

I have an access database that contains HTML code, this code is read into a textarea object that is on my page, however if this code in the database contains for example "& q u o t;" it gets converted into its appropriate HTML syntax when its read into the textarea, and then when the user clicks "Update" the database is updated with the wrong information, how can I prevent this from happening?

This is very hard to explain so please say if you dont understand...

[andreys]

use Replace() function to avoid this problem

strData=replace(request.form("YourTextAreaName"),""", """)

see what i mean

[MC_Claus]

On that note, I would like to add a question...

What if you have a MS database that contains a Memo datatype with HTML syntax in it ie <br> and you want to load that into a textarea. It shouldn't be converted into &quot; (or whatever the syntax is for < and >, I can't remember).
The text in the database should be loaded into a textarea exactly as it is written in the database!!

[Neilbaker86]

Yeh, a <br> would still be in text form but if you have the code way to display the "code" like the "& l t ;" it gets converted to its appropriate symbol when its loaded into the textarea. which i want it to stay as "& l t ;".

[Anglo Saxon]

Use server.HTMLEncode :

<textarea cols="35" rows="10">
<%
Response.Write "&lt;a href=&qu ot;page.asp&qu ot;&gt;click&lt;/a&gt;" & vbCrLf
Response.Write server.htmlencode("&lt;a href=&qu ot;page.asp&qu ot;&gt;click&lt;/a&gt;")
%>
</textarea>

remember to remove the [spaces] out of the &qu ot; in the examples above!
---

Anglo Saxon

[Neilbaker86]

Thanks Anglo Saxon it works a treat now!