3 replies to this topic

[zanelati2002]

tenho uma conexão o mesmo mostra os ultimos 10 que assinaram meu livro de visitas os email como que eu faço para quando mostrar os emails automaticamente quando mostrar o user clica e manda um email para o cara tipo um link direto para o autlook express
<%
set conn = createobject("AdoDb.connection")
constr = "Driver={Microsoft Access Driver (*.mdb)};DBQ="& server.MapPath("db/guest.mdb")
conn.open constr

set rs = conn.execute("select top 10 * from assinar order by email desc")
do while not rs.eof
response.write(rs("email")&"<br>")
rs.movenext
loop
%>

[crazybaby]

Faz assim

<%
set conn = createobject("AdoDb.connection")
constr = "Driver={Microsoft Access Driver (*.mdb)};DBQ="& server.MapPath("db/guest.mdb")
conn.open constr

set rs = conn.execute("select top 10 * from assinar order by email desc")
do while not rs.eof
response.write("<a href='mailto:"&rs("email")&"'>"&rs("email")&"</a><br>")
rs.movenext
loop
%>

Flows

[zanelati2002]

e quando o link apontar par sites
<%
set conn = createobject("AdoDb.connection")
constr = "Driver={Microsoft Access Driver (*.mdb)};DBQ="& server.MapPath("db/guest.mdb")
conn.open constr

set rs = conn.execute("select top 10 * from assinar order by site desc")
do while not rs.eof
response.write(rs("site")&"<br>")
rs.movenext
loop
%>

[crazybaby]

Só tirar o mailto

<%
set conn = createobject("AdoDb.connection")
constr = "Driver={Microsoft Access Driver (*.mdb)};DBQ="& server.MapPath("db/guest.mdb")
conn.open constr

set rs = conn.execute("select top 10 * from assinar order by site desc")
do while not rs.eof
response.write("<a href='"&rs("site")&"'>"&rs("site")&"<br>")
rs.movenext
loop
%>

Flows