SQL中text字段读出时怎么自动换行？

[kavencai]

如题，请高手帮忙，谢谢

[wsdzmhongm]

response.write replace(replace(rs("x"),vbcrlf,"<br>")," "," ")

[LiuYongSheng]

Response.Write(Server.HtmlEncode(yourString));

用这种方法不仅能解决解决换行的问题，连其他的html字符问题也能一块解决

[wsdzmhongm]

这样也不错:
<table width=500>
<tr>

<td style="word-break:break-all;">
  <%=rs("内容")%>
</td>

</tr>
</table>

[myfc]

用replace好，尽量不要用HtmlEncode

[kavencai]

to myfc(狂草)

用replace好，尽量不要用HtmlEncode，能告诉我是为什么吗？

[zhf8203]

＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
零点网络 www.cnse.cn 大量WEB技术资料免费查阅
承接各种网站建设项目 有意者请联系(Q)65538365
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊


用自定义函数

<%
Rem 过滤HTML代码
function HTMLEncode(fString)
HTMLEncode=fString
if HTMLEncode<>"" and not isnull(HTMLEncode) then
HTMLEncode = replace(HTMLEncode, ">", ">")
HTMLEncode = replace(HTMLEncode, "<", "<")
HTMLEncode = Replace(HTMLEncode, CHR(32), " ")
HTMLEncode = Replace(HTMLEncode, CHR(9), " ")
HTMLEncode = Replace(HTMLEncode, CHR(34), """)
HTMLEncode = Replace(HTMLEncode, CHR(39), "'")
HTMLEncode = Replace(HTMLEncode, CHR(124), "|")
HTMLEncode = Replace(HTMLEncode, CHR(13), "")
HTMLEncode = Replace(HTMLEncode, CHR(10) & CHR(10), "</P><P> ")
HTMLEncode = Replace(HTMLEncode, CHR(10), "<BR> ")
end if
end function
%>

[zl9732]

replace(content,chr(10)&chr(13),"<Br>")

[19az]

支持用自定义函数,自定义函数包括的比较全,如果哪一个replace不需要，只需要一屏蔽就可以了！

[fashchina]

就是替换而已
那些要替换的你写出来就是
还原的时候放过去就行了