<% Do Until rs.EOF
if request("fsdx"&rs(name))<>"" then
dim fsdx,fssj,fsnr,fszt,sffk,fsry
fsry=session("UserName")
fsdx=request.form("fsdx"&rs("name"))
fsnr=request.Form("fsnr")
fssj=now()
fszt=request.form("jjzy")
sffk=request.form("xfhqr")
Set rs = Server.CreateObject("ADODB.Recordset") '------这句删掉试试
SQL="insert into smsdata(fsdx,fssj,fsnr,fszt,sffk,fsry)values ('"+fsdx+"',#"&fssj&"#,'"+fsnr+"','"+fszt+"','"+sffk+"','"+fsry+"')"
conn.execute SQL
rs.MoveNext
Loop %>
if request("fsdx"&rs(name))<>"" then
dim fsdx,fssj,fsnr,fszt,sffk,fsry
fsry=session("UserName")
fsdx=request.form("fsdx"&rs("name"))
fsnr=request.Form("fsnr")
fssj=now()
fszt=request.form("jjzy")
sffk=request.form("xfhqr")
Set rs = Server.CreateObject("ADODB.Recordset") '------这句删掉试试
SQL="insert into smsdata(fsdx,fssj,fsnr,fszt,sffk,fsry)values ('"+fsdx+"',#"&fssj&"#,'"+fsnr+"','"+fszt+"','"+sffk+"','"+fsry+"')"
conn.execute SQL
rs.MoveNext
Loop %>