entonces me quedaria asi: ??
Set conc = Server.CreateObject("ADODB.Connection")
conc.Open "Vivienda" = AQUI YA TENGO SOLO UNA CONEXION =
Set rsc = Server.CreateObject("ADODB.Recordset")
rsc.ActiveConnection = conc
rsc.Source = "SELECT * FROM items" & " WHERE item_pertenece_a = 0" & " AND id_item = " &
....
Set rsp = Server.CreateObject("ADODB.Recordset")
rsp.ActiveConnection = conp
rsp.Source = "SELECT * FROM items" & " WHERE id_item = " & request.form("paises")
rsp.CursorType = 2
rsp.CursorLocation = 2
rsp.LockType = 3
rsp.Open
.....
ESTA BIEN ESO DE LOS RECORDSET O PUEDO HACERLO DE OTRA FORMA ???
