自己很少用Insert Into,哪位大哥能帮忙把这段代码改成 Insert Into 方法的 ,小弟先谢谢了
sql = "select * from TempImageTable where user_id= " & user_id
set rootRs = conn.execute(sql)
do while not rootRs.Bof and not rootRs.Eof
set nextRs = Server.CreateObject( "ADODB.recordSet ")
sql = "SELECT * FROM ImageTable "
nextRs.open sql,conn ,1,3
nextRs.AddNew
nextRs( "file_type ") = rootRs( "file_type ")
nextRs( "file_size ") = rootRs( "file_size ")
nextRs( "file_content ").AppendChunk rootRs( "file_content ").GetChunk(clng(rootRs( "file_size ")))
nextRs( "link_id ") = article_id
nextRs( "create_time ") = this_time
nextRs.Update
rootRs.MoveNext
loop
conn.execute "delete from TempImageTable where user_id= " & user_id
------解决方案--------------------
图片是没办法insert into的