谁帮我看看 下面的语句哪里出错?
http://topic.csdn.net/u/20080102/21/41cd9c17-4528-4cff-9203-5eeaa481149a.html 你好 这是更新数据库内容的方法
下面是我想从jydxx和hwxx检索符合条件的数据插入一张表fhqd中
这是利用hwxx表中的hw_id传值 <td width="23"> <div align="left"> <input type="checkbox" name="chk_id" id="chk_id" align="center" value="<%=rs("hw_id")%>" > </div></td>
这是处理页面
for i = 1 to request.form("chk_id").count
hw_id =replace(request.form("chk_id").item(i),", ","") '去掉空格
sql="insert into fhqd(fhrxm,fhrdh,shrxm,shrdh,zdz,sxhh,jydbh,hwmc,chang,kuang,gao,jianshu,dtj,dzl,ztj,zzl,danjia,cyf,bxf,zyf,hdfk,yijje,sqje,dzf,dshk,jjf,qdlx,thfs,beizu) select jydxx.fhrxm,jydxx.fhrdh,jydxx.shrxm,jydxx.shrdh,jydxx.zdz,jydxx.sxhh,hwxx.jydbh,hwxx.hwmc,hwxx.chang,hwxx.kuang,hwxx.gao,hwxx.jianshu,hwxx.dtj,hwxx.dzl,hwxx.ztj,hwxx.zzl,hwxx.danjia,hwxx.cyf,hwxx.bxf,hwxx.zyf,jydxx.hdfk,jydxx.yijje,jydxx.sqje,jydxx.dzf,jydxx.dshk,jydxx.jjf,jydxx.qdlx,jydxx.thfs,jydxx.beizu from hwxx,jydxx where hwxx.hw_id = '"&hw_id&"' and hwxx.jydbh=jydxx.jydbh "
conn.execute(sql)
next
怎么不行 哪里出错???请指教??