retreiving from single quates from database in asp or javascript

[rijo_mathachan]

hai,

i want to retrive data from te database in an asp page. the problem is data contains single quates, so errors are coming.
while entering i replaced single quates.


is there is any way to retreave data ..
help me please..
Rijo

[glenngv]

<input type="text" name="txt1" value="<%=Server.HTMLEncode(rs("fieldname1"))%>">

<textarea><%=Server.HTMLEncode(rs("fieldname2"))%></textarea>

[whammy]

That oughta do it.