problema nel modifica-elimina record

[zeweb]

Syntax error (missing operator) in query expression 'newsID ='.

/admin_cedab/admin/edit_it.asp, line 25

  <%
	if request.form("func") = "Modifica News" then
	Set objCon = Server.CreateObject ("ADODB.Connection")
	Set objRec = Server.CreateObject ("ADODB.Recordset")
	objCon.Open strCon
	sql = "Select * from news where newsID = "& request.form("newsID")
	objRec.Open sql, objCon, 2, 3
	objRec("titolo") = trim(request.form("titolo"))
	objRec("data") = trim(request.form("data"))
	objRec("sommario") = trim(request.form("article"))
	objRec("autore") = trim(request.form("autore"))
	objRec("fonte") = trim(request.form("fonte"))
	objRec.Update
	objRec.Close
	objCon.Close
	Set objRec = nothing
	Set objCon = nothing	
	
	elseif request.form("func") = "Elimina News" then
	Set objCon = Server.CreateObject ("ADODB.Connection")
	objCon.Open strCon
	sql = "Delete from news where newsID = "& request.form("newsID")
	objCon.execute(sql)
	objCon.Close
	Set objCon = nothing	
	end if
	response.Redirect("default.asp")
	%>

[fraude]

linea 25 ? qual'è?
e response write della query please...

[pieroseko]

ti manca il parametro newsID
sql = "Delete from news where newsID = "& request.form("newsID")

non è per caso request.Querystring ?

[zeweb]

grazie ho risolto avevo messo

<input type="hidden" name="newsID" value="<%=rec("newsID")%>">

fuori dal form

<form method="POST" action="edit_it.asp"  name="newForm" onsubmit="return checkform()">

Grazie!