rs.close
rs.open "select max(sid) maxid from service", conn
aa=rs("maxid")
response.write(aa&"<br>")
bb=Mid(aa,2,3)
response.write(bb)
response.write(bb+1)
if (bb+1)<99 then
newid=Left(aa,1) & "0" & (bb+1)
else
newid=Left(aa,1) & (bb+1)
end if
rs.open "select max(sid) maxid from service", conn
aa=rs("maxid")
response.write(aa&"<br>")
bb=Mid(aa,2,3)
response.write(bb)
response.write(bb+1)
if (bb+1)<99 then
newid=Left(aa,1) & "0" & (bb+1)
else
newid=Left(aa,1) & (bb+1)
end if
是取表service中sid字段的最大值,列名为maxid,接下去就是你的程序代码了,
输出,取值,看下来似乎找到比max(sid)这个当前最大值再大一点的sid