Hi all,

Im using the below code,

strSQL = "UPDATE comments SET closed = 'yes' WHERE (id = " & iRecordId & ")"

to update a records yes/no field in table with 'yes'. Nothing is happening though.

Could anyone tell me what i am doing wrong.

steve

ps. i know the connection is ok, it comes down to the SQL i think.
cheers

No brackets needed around the WHERE clause.

That still doesnt make any difference although I would have been surprised if it did.
My code is (i have changed yes/no in db to true/false for below example)

iRecordId = cInt(Request.Form("id"))
		strSQL = "UPDATE comments SET closed=True WHERE id = " & iRecordId 

		Set cnnDBEdit = Server.CreateObject("ADODB.Connection")
		cnnDBEdit.Open Conn
		cnnDBEdit.Execute strSQL

any errors ?

No, It processes fine. Just doesnt update the record.

ok, thanks for you time. It seems to be a selection issue and not a sql update problem.
cheers

Can't see anything wrong with the query as it stands. Response.write it out before the .execute to see if it is what you would expect.

You can paste the result into the Access query designer see if it works there.

ok missed your last post before writing mine out