关于ASP和SQL的问题..紧急求助...

[gzjacky2003]

有一篇文章,我把它写到MSSQL数据库的LONG TEXT字段后,在用RS把它显示出来,但显示出来的是一整段的文章,没有任何段落的排列,请问,如何才能把库里的数据能显示出有段落的排列啊?

[ying1234]

把显示方法和文章一起存入数据库。

[os586]

你需要进行格式替换，就是用replace()把里面的许多特殊段落格式标记替换掉然后才能正确显示你原来的格式

[fyhua]

<%=Replace(replace(replace(Rs("ep_intro"),chr(13),"<br>")," "," ")," "," ")%>

[RealDreamMan]

up

[stefli]

function DelHtml(str)
Dim tempStr
tempStr=str
If Not IsNull(tempStr) Then
tempStr=Replace(tempStr,"<","<")
tempStr=Replace(tempStr,">",">")
tempStr=Replace(tempStr,"&#","<i>&#</i>")
tempStr=Replace(tempStr,"'","'")
tempStr=Replace(tempStr,"""",""")
tempStr=Replace(tempStr,Chr(13),"")
tempStr=Replace(tempStr,Chr(10),"<br>")
tempStr=Replace(tempStr,Chr(32)," ")
tempStr=Replace(tempStr,Chr(9)," ")
DelHtml=tempStr
End If
end function


调用：
Content=DelHtml(Request.Form("Content"))