Adicionar Notícia
<% else date1 = Now() pname = request.form("name1") pdate = request.form("date1") entry1 = request.form("Entry1") ' Yeah I got quotes praise the lord he he he pname = Replace(request.form("name1"), "'", "''") pdate = request.form("date1") entry1 = Replace(Request.Form("Entry1"), "'", "''") Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.Mappath("../parnanet.mdb") &";" SQLstmt = "INSERT INTO noticias (data,chamada,noticia)" SQLstmt = SQLstmt & " VALUES (" SQLstmt = SQLstmt & "'" & pdate & "'," SQLstmt = SQLstmt & "'" & pname & "'," SQLstmt = SQLstmt & "'" & entry1 & "'" SQLstmt = SQLstmt & ")" Set RS = conn.execute(SQLstmt) %>
Sua Notícia foi postada com sucesso!
<%end if%>