Strange error in INSERT statement

[Herminio]

I have this code :

<%
dim nome
dim coment
coment = request.form(&quot;com&quot
nome = request.form(&quot;nome&quot
id = request.querystring(&quot;id&quot

Set conn = Server.CreateObject(&quot;ADODB.connection&quot
strCon = &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; & Server.MapPath(&quot;db/opiniao.mdb&quot
conn.open strcon
strOpin = &quot;insert into coments (Nome,Coment) values ('&quot;&nome&&quot;','&quot;&coment&&quot;') where idopiniao=&quot;&id;&quot;
conn.execute(strOpin)
%>

this is what's happening

for the first time the browser gave me an error saying that ( is missing at the end of instruction, and now that the ( is there it tells me &quot;expected end of instruction&quot;, can someone tell me what's wrong?

Thanks in advance

Herminio, Portugal

 

[JamesLean]

You can't have a WHERE clause in an INSERT statement. It looks like you are trying to update the row?:

strOpin = "UPDATE coments SET nome = '" & nome & "', coment = '" & coment & "' WHERE idopiniao = " & id

--James

 

[Herminio]

ok, just forget it, i have to insert the idopiniao in the DB to.

Sorry for the time i've made you spend with this silly question.

Herminio, Portugal