<% Option Explicit dim conn, RecSet, myRegExp if (Request.Form("Message") <> "") then set myRegExp = new RegExp myRegExp.Pattern = "'" myRegExp.Global = true set conn = Server.CreateObject("ADODB.Connection") conn.Open "corey" set RecSet = conn.execute("Insert into Corey values('" & _ myRegExp.Replace(Request.Form("UserName"), "''") & "', " & _ "null, '" & _ myRegExp.Replace(Request.Form("Message"), "''") & "')") set RecSet = nothing set conn = nothing end if set conn = Server.CreateObject("ADODB.Connection") conn.Open "corey" set RecSet = conn.execute("Select UserName, InsertDate, Message from Corey order by InsertDate") Response.Write("Message Board") Response.Write("") Response.Write("") Response.Write("") do while Not RecSet.Eof Response.Write("") RecSet.MoveNext Loop Response.Write("
Corey's Message Board
" & _ RecSet("UserName") & _ "" & _ RecSet("InsertDate") & _ "" & _ RecSet("Message") & _ "
") Response.Write("


Return to Main Page
") Response.Write("
") set RecSet = nothing set conn = nothing %>