从数据库读取数据显示问题(显示格式问题)大侠们帮帮我这哥菜鸟吧!!!!我再等回复

[20hao]

我建立了一个数据库,我把文章的内容保存到数据库的表中了,不过当我从网站上浏览这些数据的时候为什么没有了段落格式了,而是就一段,乱,烦.
请回复的时候说的详细点,我刚开始学,底子不好......

[zmgnwpu]

最好是把写数据库之前，把空格和回车转换成 和<br>

[xieqi]

<%=replace(replace(rs("正文"),vbcrlf,"<br>")," "," ")%>

[liujian098]

在提取显示的时候转换:
if content<>"" then
content = Replace(content, CHR(38), "&")
content = Replace(content, ">", ">")
content = Replace(content, "<", "<")
content = Replace(content, CHR(39), "'")
content = Replace(content, CHR(32), " ")
content = Replace(content, CHR(34), """)
content = Replace(content, CHR(13), "")
content = Replace(content, CHR(10), "<br>")
end if

[baikaishui_0825]

<textarea name="textarea" cols="54" readonly wrap="PHYSICAL" style="border: none;overflow: visible;height: auto; "><%=Features%></textarea>

[baikaishui_0825]

<textarea name="textarea" cols="54" readonly wrap="PHYSICAL" style="border: none;overflow: visible;height: auto; "><%=数据库读出的内容%></textarea>

[hbhbhbhbhb1021]

<script language=javascript>
var s=document.all.a123.value;
re=/\n/g;
s.replace(re,"<br>");
re=/\s/g;
s.replace(re," ");
然后再提交form
</script>
<textarea name=a123>
</textarea>

[luck0235]

已提供相关函数，你也可以搜索一下，解决过的这样的问题应该很多。

[wgf001]

在提取显示的时候转换:
if content<>"" then
content = Replace(content, CHR(38), "&")
content = Replace(content, ">", ">")
content = Replace(content, "<", "<")
content = Replace(content, CHR(39), "'")
content = Replace(content, CHR(32), " ")
content = Replace(content, CHR(34), """)
content = Replace(content, CHR(13), "")
content = Replace(content, CHR(10), "<br>")
end if

[lnboy1003]

up

[liujian098]

content=rs("相应字段")
if content<>"" then
content = Replace(content, CHR(38), "&")
content = Replace(content, ">", ">")
content = Replace(content, "<", "<")
content = Replace(content, CHR(39), "'")
content = Replace(content, CHR(32), " ")
content = Replace(content, CHR(34), """)
content = Replace(content, CHR(13), "")
content = Replace(content, CHR(10), "<br>")
end if
显示的地方为<%=content%>

[poonzsp]

replace(server.htmlcode(rs("content")),vbcrlf,"<br>")
用这个试试

[poonzsp]

大快了 .更正一下
server.htmlencode ^_^