写sql语句无法操作大容量的字符串,如sql server的text类型、
access的memo类型或oracle的long类型的字段,由于sql语句本
身长度的限制,无法写入超长的字符串,但可以使用command写入。
例如:
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
access的memo类型或oracle的long类型的字段,由于sql语句本
身长度的限制,无法写入超长的字符串,但可以使用command写入。
例如:
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10294527/viewspace-124491/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10294527/viewspace-124491/