Operation is not allowed when the object is closed.
HejJeg problemer med:
strSQL="update search SET email_sent = 'true' WHERE url_id = " & rs("url_id")
set rs = myConn.execute(strSQL)
Den siger:
Operation is not allowed when the object is closed.
________________________________________________
Set myConn=Server.CreateObject("ADODB.Connection")
myConn.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="+server.Mappath("/db/selvet.mdb"))
strSQL="select * FROM search"
set rs = myConn.execute(strSQL)
Set myConn2=Server.CreateObject("ADODB.Connection")
myConn2.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="+server.Mappath("/db/users.mdb"))
do while not rs.EOF
if rs("email_sent") = "false" then
strSQL2="select * FROM users WHERE id = " & rs("bruger_id")
set rs2 = myConn2.execute(strSQL2)
sendEmail()
if not rs2.EOF then
strSQL="update search SET email_sent = 'true' WHERE url_id = " & rs("url_id")
set rs = myConn.execute(strSQL)
end if
end if
rs.MoveNext
Loop
myConn.close
myConn2.close
