sisicn

try jmail...it works better

sql="update table_name set xxx='values' where xxx='values' "oconn.execute(sql)oconn is your connection object

try thisi=0while not rs.eof making connection to db2set rs2.open for db2while not rs2.eofdo something, get some values from both db1 and db2if i=0 then<td class="line">rs("comlumna")end if<td class="line">rs2("comlumne") here i want to add a, b, c, d, e, value to the tablei=1rs2.movenextloopclose connection to db2rs1.movenextloopor if not rs.eof thendo something, get some values from db1<td class="line">rs("comlumna")end ifwhile not rs.eof making connection to db2set rs2.open for db2while not rs2.eofdo something, get some values from db2<td class="line">rs2("comlumne") here i want to add a, b, c, d, e, value to the tablers2.movenextloopclose connection to db2rs1.movenextloop