not evaluate html from sql

[bouy]

quick question..I have some html in an mssql db and i want to response.write it without the tags being evaluated (eval as text)....?

[bouy]

p.s. classic asp

[aspdaddy]

The only way I found was to write it inside code tags and replace < with "&lt;" and > with "&gt;"

Response.write "<code>&lt;p&gt;A TEST PARAGRAPH&lt;/p&gt;</code>"

[Brad_H]

You can use Server.HTMLEncode to do this.

Response.Write(Server.HTMLEncode( Db-Variable-Here ))

[bouy]

sweet..thanks