======关于大字段的复制问题!!!!=====
mytable (ID,pic,icon)其中pic,icon均为image型
现在想在mytable中复制自身的一条记录
ID Pic Icon
101 ... ...
到
102 ... ...
方法一:
strSql="selct * from mytable where ID='101'"
if rs.state<>adStateClosed then
rs.close
end if
rs.open strSql,myCon,1
strSql="insert into mytable(ID,Pic,Icon) values('102','"&rs("pic")&"','"&rs("icon")&"')"
myCon.Execute strSql
方法二:
strSql="selct * from mytable where ID='101'"
if rs.state<>adStateClosed then
rs.close
end if
rs.open strSql,myCon,1
strSql="insert into mytable(ID) values('102')"
myCon.Execute strSql
strSql="selct * from mytable where ID='102'"
if rs1.state<>adStateClosed then
rs1.close
end if
rs1.open strSql1,myCon,1
rs1("Pic").AppendChunk trim(rs("pic"))
rs1("icon").AppendChunk trim(rs("Icon"))
rs1.close
但是两种方法都不成功!!!