<!-- #include file = "../common/act_dbopen.asp" -->
<%
	' Property of and written by Adam Ford -->
	dim CIID

	CIID = request.querystring("ciid")

	' Make sure a number was passed correctly
	if isNumeric(CIID) then
		CIID = clng(CIID)
	else
		CIID = 0
	end if

	' Create the SQL statement
	strSQL = "UPDATE Cities SET name='" & request.form("name") & "' WHERE CIID=" & CIID & ";"

'	Open a recordset
	objDBConn.execute strSQL

	on error resume next

	if err.number <> 0 then
		dim strPage
		strPage = "act_updatecity.asp"
%>
	<!-- #include file = "../common/dsp_error.asp" -->
<%
	else
		strphone = empty
		HID = empty
%>
<!-- #include file = "../common/act_dbclose.asp" -->
<%
		response.redirect ("dsp_main.asp")
	end if
%>