Update Front Page News


<% call openConn ("nothingtoit_7051") pageaction = request.form("action") if pageaction = "process" then 'the user has submitted this form and wants the data updated in the DB newsone = CleanString(request.form("newsone")) SQL = "UPDATE newsone_tbl SET newsone = '"&newsone&"';" call openCMD (SQL) response.write "The data has been updated and will now read:

" SQL = "SELECT * FROM NEWSONE_TBL;" call openRS (SQL) response.write "" response.write "

"& cleanHTMLstring(rs("newsone")) & "

" else 'the user is at a blank form response.write "
" response.write "

" response.write "" response.write "
" end if call cleanup%>