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
%>
Como Fazer Isto Me Confundo
Started By zanelati2002, 25/12/2003, 08:21
3 replies to this topic
#1
Posted 25/12/2003, 08:21
#2
Posted 25/12/2003, 09:14
Faz assim
Flows
<% 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
#3
Posted 25/12/2003, 09:23
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
%>
<%
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
%>
#4
Posted 25/12/2003, 09:28
Só tirar o mailto
Flows
<% 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
1 user(s) are reading this topic
0 membro(s), 1 visitante(s) e 0 membros anônimo(s)