mmmm ok si eso es lo que quiero hacer , pero me
hago bolas
cuando uso los recordset, por ejemplo tengo esto:
----------------------------------------
Set conc = Server.CreateObject("ADODB.Connection")
conc.Open "Vivienda"
Set rsc = Server.CreateObject("ADODB.Recordset")
rsc.ActiveConnection = conc
rsc.Source = "SELECT * FROM items" & " WHERE item_pertenece_a = 0" & " AND id_item = " & request.form("continentes")
rsc.CursorType = 2
rsc.CursorLocation = 2
rsc.LockType = 3
rsc.Open
descripc = rsc("item_descripcion")
rsc.Close
Set rsc = Nothing
Set conp = Server.CreateObject("ADODB.Connection")
conp.Open "Vivienda"
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
If not (rsp.EOF) then
descrippa = rsp("item_descripcion")
else
descrippa= "-"
descripse= "-"
end if
rsp.Close
Set rsp = Nothing
------------------------------------------------
ahi tengo dos select, asi estan bien ???