!!!!!求助!!!!!高手帮帮忙!!再线等!
存储一段文章memo,在到数据库,字段类型为text型,数据库为SQL。
memo = Request("textarea1")
memo = Replace(memo, "&", "&")
memo = Replace(memo, "<", "<")
memo = Replace(memo, ">", ">")
memo = Replace(memo, " ", " ")
memo = Replace(memo, vbCrLf, "<br>")
set conn=server.createobject("adodb.connection")
Connstr="Provider=SQLOLEDB;Data Source=hf;UID=sa;PWD=sa;DataBase=BCAWeb"
conn.open connstr
set rec=server.createobject("adodb.recordset")
rec.open "select * from BCAWeb_New where id is null ",conn,1,3
rec.addnew
rec("title") = title
rec("memo") = memo
rec.update
rec.close
set rec=nothing
set conn=nothing
为什么不能把完整的文章存进去,只能存一部分,显示的时候只能显示存的一部分,
以下为显示代码:
<td><%=rs("memo")%><br><br>
</td>