ASP Response.wrirte - Usando Join no InterBase

[pepa_roller]

Ola galera .. to com um probleminha para dar um response.write no asp

fiz um join... mas na hora de far o response da erro...

Objeto necessário "

Esta assim

<%

Set rs3 = conexao.Execute("select * from login lo, agenda ag, tarefa ta where lo.login = '"&usuario&"' and ag.status = 'I' and ag.cod_reme = lo.cod_func and ta.cod_afazer = ag.cod_afazer")

DO WHILE not rs3.eof

%>

<table border="1" width="90%">

<tr>

<td><b>Tarefa: </b><%response.write tarefa.nome%><p>

<b>Inicio: </b><%response.write agenda.data_inicio%>  <%response.write agenda.hora_inicio%></p>

<p>

<b>Limite:</b><%response.write agenda.data_limite%>  <%response.write agenda.hora_limite%></p>

<p><b>Status: Não Realizada</b></td>

</tr>

<!-- teste assim funciona

<%response.write rs3(0)%><br>

<%response.write rs3(1)%><br>

<%response.write rs3(2)%><br>

<%response.write rs3(3)%><br>

<%response.write rs3(4)%><br>

<%response.write rs3(5)%><br>

<%response.write rs3(6)%><br>

<%response.write rs3(7)%><br>

<%response.write rs3(8)%><br>

<%response.write rs3(9)%><br>

<%response.write rs3(10)%><br>

<%response.write rs3(11)%><br>

<%response.write rs3(12)%><br>

<%response.write rs3(13)%><br>

<%response.write rs3(14)%><br>

<%response.write rs3(15)%><br>

<%response.write rs3(16)%><br>

<%response.write rs3(17)%><br>

<%response.write rs3(18)%><br>

<%response.write rs3(19)%><br>

<%response.write rs3(20)%><br>

-->

</table></br></br></br>

<%

rs3.movenext

Loop

rs3.close

%>

<%conexao.close%>

</TD>

</tr>

</TABLE>

tentei assim tb mais não deu certo

response.write ag.hora_limite

colocando o apelido da tabela

[pepa_roller]

Resolvido assim

<%response.write rs3 ("hora_inicio")%>