Avatar billede akr21jb Nybegynder
20. juni 1999 - 22:53 Der er 11 kommentarer og
1 løsning

Jmail hos Digiweb

jeg har prøvet at sætte JMail ind i følgende prg. Det skal sende en mail hvis man har glemt sit password, men jeg kan ikke rigtigt
få det til at virke. Er der nogen der kan hjælpe?
Jeg får følgende fejl:
Microsoft VBScript runtime error ''800a01b6''
Object doesn''t support this property or method: ''Jmail.AddRecipient''
/forum/pword.asp, line 35
Jeg syntes selv jeg har prøvet alt, men jeg gør altså et eller andet
forkert, men hvad?
Jeg er meget i tvivl om hvordan linien
Set smtp = Server.CreateObject("SmtpMail.SmtpMail.1")    skal se ud. Ser det forkert ud eller hvad ?

Efter koden nedenunder er den originale for at sammenligne.

if Request.QueryString("mode") = "doit" then

Set Jmail = Server.CreateObject("Jmail.SMTPMail")
set my_conn= Server.CreateObject("ADODB.Connection")
my_Conn.Open ConnString

MailServer = "smtp.mit-domain.dk:25"
Recipients = ("email")
Sender = "ross@post3.tele.dk"
Subject = "ASP Forum Password"
mssg = "You have received this mail because you have asked to be reminded
of you password"
mssg = mssg & "For the ASP Forum at http://www.asp-dev.ml.org" & vbCrLf &
vbCrLf


strSql = "Select M_name, M_Password, M_Email from members where M_Name = ''"
strSql = strSql & Request.Form("Name") & "'' and M_Email =''"
strSql = strSql & Request.Form("email") & "''"

set rs = my_conn.Execute (StrSql)

if rs.EOF or rs.BOF then
  mssg = mssg & "Sorry The details you passed were unknown." & vbCrLf &
vbCrLf
  mssg = mssg & "Please register again at
http://www.asp-dev.ml.org/forum/register.asp" & vbCrLf
Else
  mssg = mssg & " Your Password id :- " & rs("M_Password") & vbCrLf
End if

mssg = mssg & "Thank you for using the ASP Forum"


JMail.ServerAddress = MailServer
JMail.AddRecipient = Recipients
JMail.Sender = Sender
JMail.Subject = Subject
JMail.Body = mssg
smtp.SendMail2
Set smtp = Nothing
on error resume next
rs.close
set rs=nothing
my_conn.Close
set my_conn = nothing
JMail.Execute
%>
<html>

<head>
<title></title>
</head>

<body>

<p align="center"><font face="veranda, Arial, Helvetica" size="4">Password
Reminder</p>

<p align="center"><font face="veranda, Arial, Helvetica" size="2">You should
receive an
email any moment now!</p>
<%
Else
%>

<p align="center"><font face="veranda, Arial, Helvetica" size="4">Password
Reminder</p>

<form action="pword.asp?mode=doit" method="post">
  <div align="center"><table background bgColor="#b0c4de" border="1"
borderColor="#000000"
  cellPadding="0" cellSpacing="0" width="70%">
<TBODY>
    <tr>
      <td width="50%"><font face="veranda, Arial, Helvetica" size="2">User
Name </font></td>
      <td width="50%"><font face="veranda, Arial, Helvetica" size="3"><input
name="Name"
      size="30"> </font></td>
    </tr>
    <tr>
      <td><font face="veranda, Arial, Helvetica" size="2">Email</font></td>
      <td><font face="veranda, Arial, Helvetica" size="3"><input
name="email" size="30"
      type="password" value></font></td>
    </tr>
    <tr>
      <td align="middle" colSpan="2"><input name="submit1" type="submit"
value="Submit"></td>
    </tr>
</TBODY>
  </table>
  </font></TBODY>
<p>&nbsp;</p>
<%
End if
%>
  </div>
</form>
</font></font>
</body>
</html>

originalen kommer her:

if Request.QueryString("mode") = "doit" then

Set smtp = Server.CreateObject("SmtpMail.SmtpMail.1")
set my_conn= Server.CreateObject("ADODB.Connection")
my_Conn.Open ConnString

MailServer = "mail1.stoneplanet.com"
Recipients = request.form("email")
Sender = "asp@asp-dev.ml.org"
Subject = "ASP Forum Password"
mssg = "You have received this mail because you have asked to be reminded
of you password"
mssg = mssg & "For the ASP Forum at http://www.asp-dev.ml.org" & vbCrLf &
vbCrLf


strSql = "Select M_name, M_Password, M_Email from members where M_Name = ''"
strSql = strSql & Request.Form("Name") & "'' and M_Email =''"
strSql = strSql & Request.Form("email") & "''"

set rs = my_conn.Execute (StrSql)

if rs.EOF or rs.BOF then
  mssg = mssg & "Sorry The details you passed were unknown." & vbCrLf &
vbCrLf
  mssg = mssg & "Please register again at
http://www.asp-dev.ml.org/forum/register.asp" & vbCrLf
Else
  mssg = mssg & " Your Password id :- " & rs("M_Password") & vbCrLf
End if

mssg = mssg & "Thank you for using the ASP Forum"


smtp.MailServer = MailServer
smtp.Recipients = Recipients
smtp.Sender = Sender
smtp.Subject = Subject
smtp.Message = mssg
smtp.SendMail2
Set smtp = Nothing
on error resume next
rs.close
set rs=nothing
my_conn.Close
set my_conn = nothing
%>
<html>

<head>
<title></title>
</head>

<body>

<p align="center"><font face="veranda, Arial, Helvetica" size="4">Password
Reminder</p>

<p align="center"><font face="veranda, Arial, Helvetica" size="2">You should
receive an
email any moment now!</p>
<%
Else
%>

<p align="center"><font face="veranda, Arial, Helvetica" size="4">Password
Reminder</p>

<form action="pword.asp?mode=doit" method="post">
  <div align="center"><table background bgColor="#b0c4de" border="1"
borderColor="#000000"
  cellPadding="0" cellSpacing="0" width="70%">
<TBODY>
    <tr>
      <td width="50%"><font face="veranda, Arial, Helvetica" size="2">User
Name </font></td>
      <td width="50%"><font face="veranda, Arial, Helvetica" size="3"><input
name="Name"
      size="30"> </font></td>
    </tr>
    <tr>
      <td><font face="veranda, Arial, Helvetica" size="2">Email</font></td>
      <td><font face="veranda, Arial, Helvetica" size="3"><input
name="email" size="30"
      type="password" value></font></td>
    </tr>
    <tr>
      <td align="middle" colSpan="2"><input name="submit1" type="submit"
value="Submit"></td>
    </tr>
</TBODY>
  </table>
  </font></TBODY>
<p>&nbsp;</p>
<%
End if
%>
  </div>
</form>
</font></font>
</body>
</html>



Avatar billede s Nybegynder
20. juni 1999 - 23:04 #1
Linien
JMail.AddRecipient = Recipients

skal istedet hede
JMail.AddRecipient    ( Recipients )

og så skal parentesen fjernes så linien
Recipients = ("email")

istedet bare hedder
Recipients = "email"

hvis det er et databaseopslag skal den selvfølgelig hede noget andet.


Håber det virker.


M.v.h.

      Svend H. B. Henriksen.
Avatar billede akr21jb Nybegynder
20. juni 1999 - 23:38 #2
Jeg har prøvet ovenstående, men det virker stadigvæk ikke, jeg får samme fejlmelding. Og ja det er et databaseopslag. Kom endelig med et nyt forslag.
Mvh Anders
Avatar billede Dan Nim Seniormester
20. juni 1999 - 23:56 #3
Jeg skal godt lave det for dig !.

Kontakt mig via dna@chatstuff.dk eller icq#5637764

Så finder vi hurtigt ud af noget !
Avatar billede kermit Nybegynder
21. juni 1999 - 00:05 #4
if Request.QueryString("mode") = "doit" then

Dim Jmail

Set Jmail = Server.CreateObject("Jmail.SMTPMail")
set my_conn= Server.CreateObject("ADODB.Connection")
my_Conn.Open ConnString

Recipients = Request.Form ("Email")
MailServer = "smtp.mit-domain.dk:25"
Sender    = "ross@post3.tele.dk"
Subject    = "ASP Forum Password"
mssg        = "You have received this mail because you have asked to be reminded of you password"
mssg      = mssg & "For the ASP Forum at http://www.asp-dev.ml.org" & vbCrLf & vbCrLf


strSql = "Select M_name, M_Password, M_Email from members where M_Name = '"
strSql = strSql & Request.Form("Name") & "' and M_Email ='"
strSql = strSql & Request.Form("email") & "'"

set rs = my_conn.Execute (StrSql)

if rs.EOF or rs.BOF then
  mssg = mssg & "Sorry The details you passed were unknown." & vbCrLf & vbCrLf
  mssg = mssg & "Please register again at http://www.asp-dev.ml.org/forum/register.asp" & vbCrLf

Else
  mssg = mssg & " Your Password id :- " & rs("M_Password") & vbCrLf
End if

mssg = mssg & "Thank you for using the ASP Forum"


JMail.ServerAddress = MailServer
JMail.AddRecipient = Recipients
JMail.Sender = Sender
JMail.Subject = Subject
JMail.Body = mssg
on error resume next
rs.close
set rs=nothing
my_conn.Close
set my_conn = nothing
JMail.Execute
Set JMail=Nothing
%>
<html>

<head>
<title></title>
</head>

<body>

<p align="center"><font face="veranda, Arial, Helvetica" size="4">Password
Reminder</p>

<p align="center"><font face="veranda, Arial, Helvetica" size="2">You should
receive an
email any moment now!</p>
<%
Else
%>

<p align="center"><font face="veranda, Arial, Helvetica" size="4">Password
Reminder</p>

<form action="pword.asp?mode=doit" method="post">
  <div align="center"><table background bgColor="#b0c4de" border="1"
borderColor="#000000"
  cellPadding="0" cellSpacing="0" width="70%">
<TBODY>
    <tr>
      <td width="50%"><font face="veranda, Arial, Helvetica" size="2">User
Name </font></td>
      <td width="50%"><font face="veranda, Arial, Helvetica" size="3"><input
name="Name"
      size="30"> </font></td>
    </tr>
    <tr>
      <td><font face="veranda, Arial, Helvetica" size="2">Email</font></td>
      <td><font face="veranda, Arial, Helvetica" size="3"><input
name="email" size="30"
      type="password" value></font></td>
    </tr>
    <tr>
      <td align="middle" colSpan="2"><input name="submit1" type="submit"
value="Submit"></td>
    </tr>
</TBODY>
  </table>
  </font></TBODY>
<p>&nbsp;</p>
<%
End if
%>
  </div>
</form>
</font></font>
</body>
</html>
Avatar billede s Nybegynder
21. juni 1999 - 00:12 #5
Der skulle laves et opslag i databasen efter emailadressen. Den skulle ikke bare hentes via Request.Form ("Email") (eller forstod jeg det forkert???)
Avatar billede kermit Nybegynder
21. juni 1999 - 09:26 #6
sorry
Avatar billede s Nybegynder
21. juni 1999 - 10:39 #7
Så prøv med:





if Request.QueryString("mode") = "doit" then

Dim Jmail

Set Jmail = Server.CreateObject("Jmail.SMTPMail")
set my_conn= Server.CreateObject("ADODB.Connection")
my_Conn.Open ConnString


strSql = "Select M_name, M_Password, M_Email from members where M_Name = '"
strSql = strSql & Request.Form("Name") & "' and M_Email ='"
strSql = strSql & Request.Form("email") & "'"

set rs = my_conn.Execute (StrSql)


Recipients = rs("M_Email")
MailServer = "smtp.mit-domain.dk:25"
Sender    = "ross@post3.tele.dk"
Subject    = "ASP Forum Password"
mssg        = "You have received this mail because you have asked to be reminded of you password"
mssg      = mssg & "For the ASP Forum at http://www.asp-dev.ml.org" & vbCrLf & vbCrLf


if rs.EOF or rs.BOF then
  mssg = mssg & "Sorry The details you passed were unknown." & vbCrLf & vbCrLf
  mssg = mssg & "Please register again at http://www.asp-dev.ml.org/forum/register.asp" & vbCrLf

Else
  mssg = mssg & " Your Password id :- " & rs("M_Password") & vbCrLf
End if

mssg = mssg & "Thank you for using the ASP Forum"


JMail.ServerAddress = MailServer
JMail.AddRecipient = (  Recipients  )
JMail.Sender = Sender
JMail.Subject = Subject
JMail.Body = mssg
on error resume next
rs.close
set rs=nothing
my_conn.Close
set my_conn = nothing
JMail.Execute
Set JMail=Nothing
%>
<html>

<head>
<title></title>
</head>

<body>

<p align="center"><font face="veranda, Arial, Helvetica" size="4">Password
Reminder</p>

<p align="center"><font face="veranda, Arial, Helvetica" size="2">You should
receive an
email any moment now!</p>
<%
Else
%>

<p align="center"><font face="veranda, Arial, Helvetica" size="4">Password
Reminder</p>

<form action="pword.asp?mode=doit" method="post">
  <div align="center"><table background bgColor="#b0c4de" border="1"
borderColor="#000000"
  cellPadding="0" cellSpacing="0" width="70%">
<TBODY>
    <tr>
      <td width="50%"><font face="veranda, Arial, Helvetica" size="2">User
Name </font></td>
      <td width="50%"><font face="veranda, Arial, Helvetica" size="3"><input
name="Name"
      size="30"> </font></td>
    </tr>
    <tr>
      <td><font face="veranda, Arial, Helvetica" size="2">Email</font></td>
      <td><font face="veranda, Arial, Helvetica" size="3"><input
name="email" size="30"
      type="password" value></font></td>
    </tr>
    <tr>
      <td align="middle" colSpan="2"><input name="submit1" type="submit"
value="Submit"></td>
    </tr>
</TBODY>
  </table>
  </font></TBODY>
<p>&nbsp;</p>
<%
End if
%>
  </div>
</form>
</font></font>
</body>
</html>
Avatar billede akr21jb Nybegynder
21. juni 1999 - 16:51 #8
Jeg har prøvet jeres forslag men får nedenstående fejl:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'AddRecipient'

Henholdsvis linie 37 og 40
Avatar billede Dan Nim Seniormester
21. juni 1999 - 21:14 #9
jeg har sendt dig et færdig script !.

Avatar billede akr21jb Nybegynder
21. juni 1999 - 21:20 #10
Chatstuff er kommet med løsningen, men tak for hjælpen
Avatar billede Dan Nim Seniormester
21. juni 1999 - 21:24 #11
så lidt :o)
Avatar billede akr21jb Nybegynder
21. juni 1999 - 21:30 #12
Tak for din hjælp Chatstuff
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester