April 14th, 2003, 07:43 AM
how do i run 2 pieces of sql at the same time on the same page?
i want to run two pieces of sql that connect to two different tables that are not assosiated with each other, in 1 asp file. how do i do this.
i have one at the moment
set adoConn = Server.CreateObject("adodb.connection")
make_connection adoConn, ........
set adoRsBlah = Server.CreateObject ("adodb.recordset")
sSqlSelectBlah ="SELECT foo from bar ......."
adosRsBlah.open sSqlSelectBlah, adoConn, 3
how would i include a second piece of sql that accesses a different table?
April 14th, 2003, 02:04 PM
Just create a second recordset object and a second querey and then open it just like the first.
adoRS2.open sql2, adoconn