--- title: "Mailinglista fungerar ej" type: "forum-thread" url: "https://www.webforum.nu/amne/asp/6996-mailinglista-fungerar-ej" topic: "ASP" topic_url: "https://www.webforum.nu/amne/asp" author: "kristoffer" published: "2000-10-31T23:23:00.000Z" updated: "2000-10-31T23:47:00.000Z" replies: 1 views: 158 page: 1 pages: 1 language: "sv-SE" site: "webForum — webforum.nu" rights: "Upphovsrätten till varje inlägg tillhör dess författare." attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/6996-mailinglista-fungerar-ej" --- # Mailinglista fungerar ej ## #1 — kristoffer, 2000-10-31T23:23Z Jag får felmeddelandet \[Microsoft\]\[ODBC Microsoft Access Driver\] Operation must use an updateable query. mail_ac.asp, line 18 , när jag försöker lägga till en post i databasen. Koden ser ut så här: mail.htm ``` ``` mail_ac.asp ``` <% Dim email, con, data_source, sql_insert, sql_check, rs email = Request.Form("email") If Len(email) Then Set con = Server.CreateObject("ADODB.Connection") con.Open("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("mail.mdb")) sql_check = "select email from users where email = '" & email & "'" sql_insert = "insert into users ( email )" sql_insert = sql_insert & " values ('" & email & "')" Set rs = con.Execute (sql_check, , 1) If rs.EOF Then con.execute(sql_insert) Response.Write "Thank you. Your email address " & email & _ " was successfully entered into the database" Else Response.Write "Your email address " & email & _ " is already present in the database. Thank you." End If con.Close Set con = Nothing Else Response.Redirect "mail.htm" End If %> ``` Vad beror det på? Permalänk: https://www.webforum.nu/p/6996 ## #2 — sgtpepper, 2000-10-31T23:47Z Använd sökfunktionen, den där frågan har ställts flera gånger förut. Kolla här: Permalänk: https://www.webforum.nu/p/251444 --- Tråden på webben: https://www.webforum.nu/amne/asp/6996-mailinglista-fungerar-ej