Se selv:
dim referat
dato = request.form("dato")
referent = request.form("referent")
fravaer = request.form("fravaer")
referat = Request.Form("referat")
Response.Write nummer
repreferat = chr(39) & chr(39)
referat = replace(referat,chr(39),repreferat)
Set Conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.RecordSet")
conn.Open tempConn
SQL = "Insert into referat ( dato, referent, fravaerende, referat ) values ( '"&dato&"', '"&referent&"', '"&fravaer&"', '"&referat&"' )"
Conn.execute (SQL)
Sub TLdelaySec(DelaySeconds)
SecCount = 0
Sec2 = 0
While SecCount < DelaySeconds + 1
Sec1 = Second(Time())
If Sec1 <> Sec2 Then
Sec2 = Second(Time())
SecCount = SecCount + 1
End If
Wend
End Sub
TLdelaySec(3)
Set IDConn = Server.CreateObject("ADODB.Connection")
sql2 = "select top 1 * from referat order by referatID desc;"
IDConn.Open tempConn
Set rs2 = IDConn.execute (sql2)
If Not (rs2.BOF Or rs2.EOF) Then
do While Not rs2.EOF
nummer = rs2("referatID")
rs2.MoveNext
Loop
Else
End If
IDConn.Close
Set IDConn = Nothing
'Abonnementer
Set JMail = Server.CreateObject("JMail.SMTPMail")
' This is my local SMTP server
JMail.ServerAddress = "172.16.40.20:25"
' This is me....
JMail.Sender = "aida@aida.dk"
JMail.Subject = "Nyt ledelsesreferat"
' Get the recipients mailbox from a form (note the lack of a equal sign).
Set abConn = Server.CreateObject("ADODB.Connection")
abonConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../brugere/brugere.mdb") & ";UID=admin;PWD=;"
strSQL = "SELECT * FROM nyhed where ledelse = yes"
abConn.Open abonConn
Set rs = abConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
do While Not rs.EOF
JMail.AddRecipient rs("email")
rs.MoveNext
Loop
Response.Write "</table>"
Else
Response.Write "<p><font face=arial size=2></font></p>"
End If
abconn.Close
JMail.body = "Der et nyt ledelsesreferat på AIDA" & vbcrlf & vbcrlf & "Se det på
http://aida2000/ledelsesinfo/referater.asp?mode=vis_referat&id=" & nummer &_
vbcrlf & vbcrlf & "Du kan ændre dine abonnementer på AIDA her:
http://aida2000/brugere/login.asp"' 1 - highest priority (Urgent)
' 3 - normal
' 5 - lowest
JMail.Priority = 3
JMail.AddHeader "Originating-IP", Request.ServerVariables("REMOTE_ADDR")
' Send it...
JMail.Execute