Hvor er fejlen?
Hvorfor sender den flere 100 mails til en email i dette script?<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
Set Conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("news.mdb")
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "Select * From news"
rs.Open strSQL, Conn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs("Nyhed") = Request.form("Nyhed")
rs("Over") = Request.form("Over")
rs("dato") = day(date) & "/" & month(date)
rs("kl") = time
rs.Update
rs.Close
Set rs = Nothing
Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.ServerAddress = "mail.adichat.dk"
JMail.Sender = "mail@adichat.dk"
JMail.SenderName = "TaC"
JMail.Subject = Request.form("Over")
Set Conn2 = Server.CreateObject("ADODB.Connection")
conn2.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../tacmail/database.mdb")
set book = conn2.Execute("SELECT * FROM users")
Do until book.EOF
test = book("email")
if book("mailing") = "1" Then
JMail.AddRecipient test
end if
loop
book.movenext
conn2.close
set conn2 = nothing
JMail.Body = Request.form("Nyhed")
JMail.Priority = 3
JMail.Execute
response.redirect "news.asp"
%>
