|
|
<%= atitolo %> |
<%= atesto %> |
A: <%= adestinatario %><%= aemail1 %>De: <%= amittente %><%= aemail2 %> |
" response.write "Numero=" & err.number & "
" response.write "Descrizione.=" & err.description & "
" response.write "Help Context=" & err.helpcontext & "
" response.write "Help Path=" & err.helppath & "
" response.write "Native Error=" & err.nativeerror & "
" response.write "Source=" & err.source & "
" response.write "SQLState=" & err.sqlstate & "
" end if IF conn.errors.count> 0 then response.write "Errore accesso database" & "
" response.write rs & "
" for counter= 0 to conn.errors.count response.write "Errore #" & conn.errors(counter).number & "
" response.write "Descrizione. -> " & conn.errors(counter).description & "
" next Conn.Close set conn = nothing else Conn.Close set conn = nothing Set Conn = Server.CreateObject("ADODB.Connection") strConn="DRIVER={Microsoft Access Driver (*.mdb)}; " strConn=strConn & "DBQ=" & server.MapPath("/mdb-database/kort.mdb") Conn.Open strConn sql = "SELECT * FROM kort WHERE destinatario = " sql = sql & "'" & adestinatario & "'" sql = sql & " AND pass = " sql = sql & apass sql = sql & " ORDER BY id DESC;" 'rs.Open sqlstmt,conn,3,3 set rs = conn.Execute(sql) id = rs("id") Conn.Close Set conn = nothing nomeDominio = Request.ServerVariables ("HTTP_HOST") dim mailbody scriptname = Request.ServerVariables("script_name") scriptname = Replace(scriptname,"postale.asp","visione.asp") scriptname = "http://" & nomeDominio & scriptname mailbody = amittente & " te ha enviado una postal / ti ha inviato una cartolina" & Vbcrlf & vbcrlf mailbody = mailbody & "Puedes verla en la página / Puoi vederla alla pagina :" & vbcrlf mailbody = mailbody & ScriptName & "?id=" & id & "&pass=" & apass mailbody = mailbody & vbcrlf & vbcrlf mailbody = mailbody & "O visitar/O visitare " & scriptname & vbcrlf mailbody = mailbody & "Y introducir/E inserire" & vbcrlf mailbody = mailbody & "Id Postal/Id Cartolina = " & id & vbcrlf mailbody = mailbody & "Password Postal/Cartolina = " & apass & vbCrlf & vbcrlf blabla = "Postal de/ Cartolina da " & amittente 'Response.Write mailbody DIM iMsg, Flds, iConf 'Create message and configuration objects Set iMsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.Configuration") Set Flds = iConf.Fields Flds(cdoSendUsingMethod) = cdoSendUsingPort Flds(cdoSMTPServer) = "smtp.aruba.it" Flds(cdoSMTPServerPort) = 25 Flds(cdoSMTPAuthenticate) = cdoAnonymous ' 0 Flds.Update With iMsg Set .Configuration = iConf .To = aemail1 .Sender = aemail2 .Subject = blabla .TextBody = mailbody .Send End With %>
|
|