<%
id = request.querystring("id")
if request.form = "" then
'No submit yet
if id <> "" then
'Get existing data
sqltext = "SELECT * FROM Careers WHERE id = " & id
rs.Open sqltext, Conn
Title = trim(rs("Title"))
Description = trim(rs("Description"))
rs.close
end if
else
'Update/Insert
Message = "Error Processing request"
if id <> "" then
sqltext = "SELECT * FROM Careers WHERE id = " & id
rs.Open sqltext, Conn,2,2
else
sqltext = "SELECT * FROM Careers"
rs.Open sqltext, Conn,2,2
rs.AddNew
end if
rs("Title") = request.form("Title")
rs("Description") = request.form("Description")
rs.Update
rs.close
response.redirect "index.asp"
end if
Conn.close
%>
Morris Pickering & Sanner - Admin
Morris Pickering & Sanner - Career Creator/Updater
<%= Message %>