wanni

In <td class="line">, class="line" is about the class from the CSS stylesheet,that got nothing to do with adding data to the table, those are only for display style...And about the lines coming out twice on the table is because of the loop.while not rs.eof making connection to db2set rs2.open for db2while not rs2.eofdo something, get some values from both db1 and db2<td class="line">rs("comlumna")<td class="line">rs2("comlumne") here i want to add a, b, c, d, e, value to the tablers2.movenextclose connection to db2rs1.movenextfor every record in the "rs" a connection is opened and data is printed out in the table. so thats how you are getting repeated data...

<{POST_SNAPBACK}>

there is no error message, but the output is wrong, each data is printed twice on the table ( lines are repeated on the table)

<{POST_SNAPBACK}>

This is how it goes dim oConn1, oConn2, rs1, rs2set oConn1 = Server.CreateObject("ADODB.Connection")set oConn2 = Server.CreateObject("ADODB.Connection")set rs1 = Server.CreateObject("ADODB.Recordset")set rs2 = Server.CreateObject("ADODB.Recordset")oConn1.Open [Connection info for db1]oConn2.Open [Connection info for db2]rs1.Open "someSQL", oConn1rs2.Open "someSQL", oConn2what you are doing seems correct, can you post the error you are getting..

<{POST_SNAPBACK}>

Here is what I want to doon my asp page I have following tableA B C D E Fcolumn A,B,C is from sql database db1, Column D, E is from sql database db2, F is D-CThis is what I did so far ://making connection to db1 //set rs.open for db1//while not rs.eof//making connection to db2//set rs2.open for db2//while not rs2.eof//do something, get some values from both db1 and db2//<td class="line">rs("comlumna")//<td class="line">rs2("comlumne") //here i want to add a, b, c, d, e, value to the table//rs2.movenext//close connection to db2//rs1.movenext//close neection to db1but this doesn't work , can anyone help me to find out where is the problem ?thanks