◆◆◆各位帮忙啊，为什么会每次都添加两次一样的记录到数据库，谢谢

[bandrui]

代码如下

for i=1 to 10
strGZXC=checkstr(request.form("szgzxc"&i))
if len(strGZXC)>6 then
sql="insert into ReportWeek_SZZD (JHBH,ZDNR,DCZK,WDYY) values ('"&strbh&"','"&strGZXC&"','"&checkstr(request.form("szdcqk"&i))&"','"&checkstr(request.form("szwdyy"&i))&"')"
conn.execute(sql)
else
exit for
end if
next
'===============================================================================
for kk=1 to 10
strGZXC2=checkstr(request.form("bzgzxc"&kk))
if len(strGZXC2)>6 then
sql="insert into ReportWeek_BZJH (JHBH,JHNR,DCZK,WDYY) values ('"&strbh&"','"&strGZXC2&"','"&checkstr(request.form("bzdcqk"&kk))&"','"&checkstr(request.form("bzwdyy"&kk))&"')"
conn.execute(sql)
else
exit for
end if
next
'===============================================================================
for ii=1 to 4
strGZXC3=trim(checkstr(request.form("xxtsx"&ii)))
if len(strGZXC3)>6 then
conn.execute("insert into ReportWeek_XTSX (JHBH,SXNR) values ('"&strbh&"','"&strGZXC3&"')")
else
exit for
end if
next

[泡面之夏]

sql参数不要用同样的名称，试试！

[bandrui]

3个循环，添加到数据库的时候每条数据都会重复一次添加到不同的数据库

[lychome]

你这种方法就不对....

[BoyHaXin]

确实，仔细跟踪一下IF和FOR的条件，结果可能是你想法之外的.

[zzxap]

[CODE=HTML]

for i=1 to 10
strGZXC=checkstr(request.form("szgzxc"&i))
if len(strGZXC)>6 then
sql1="insert into ReportWeek_SZZD (JHBH,ZDNR,DCZK,WDYY) values ('"&strbh&"','"&strGZXC&"','"&checkstr(request.form("szdcqk"&i))&"','"&checkstr(request.form("szwdyy"&i))&"')"
conn.execute(sql1)
else
exit for
end if
next
'===============================================================================
for kk=1 to 10
strGZXC2=checkstr(request.form("bzgzxc"&kk))
if len(strGZXC2)>6 then
sql2="insert into ReportWeek_BZJH (JHBH,JHNR,DCZK,WDYY) values ('"&strbh&"','"&strGZXC2&"','"&checkstr(request.form("bzdcqk"&kk))&"','"&checkstr(request.form("bzwdyy"&kk))&"')"
conn.execute(sql2)
else
exit for
end if
next
'===============================================================================
for ii=1 to 4
strGZXC3=trim(checkstr(request.form("xxtsx"&ii)))
if len(strGZXC3)>6 then
conn.execute("insert into ReportWeek_XTSX (JHBH,SXNR) values ('"&strbh&"','"&strGZXC3&"')")
else
exit for
end if
next
[/CODE]

[zzxap]

sql同名了