gei.asp页面
id=trim(request.QueryString("id"))
type1=trim(request.QueryString("type"))
id2=request.form("id2")
set rs=server.CreateObject("ADODB.Recordset")
sqll=conn.execute("select id2 from s where id="id)
if id>id2 then
a=id
b=id2
else
a=id2
b=id
end if
for i=b to a
conn.execute "update s set id2=id2+1 where id2="&i
next
conn.execute "update s set id2="&id2&" where id2="&id
这样应该可以的,你调一下吧