日期:2014-05-18  浏览次数:20577 次

请教,谁能帮忙改一下下面这段代码 addnew -> Insert Into
自己很少用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的