您的位置:寻梦网首页编程乐园Java天地JSP 专辑JSP001 HTML 离线版
Java 天地
JSP001 HTML 离线版
精选文章 >> SQL之家 >> 如何操作大容量的字符串,特别是在SQL下?

由 amtd 发布于: 2001-02-13 18:40

Post

如何操作大容量的字符串
dim dataconn
Set DataConn = Server.CreateObject("ADODB.Connection")
dataconn.open "yourDSN","yourName","yourPass"
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set InsertCursor = Server.CreateObject("ADODB.Recordset")
    cmdTemp.CommandText = _
"SELECT *, UserName FROM yourField WHERE (UserName IS NULL)"
    cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn
    InsertCursor.Open cmdTemp, , 1, 3
    InsertCursor.AddNew
InsertCursor("yourMemo") =strMemo
    InsertCursor.Update
    InsertCursor.close
    dataConn.close


__________________



资料来源: JSP001.com