Update statement quote problem 1

[boatdrinks]

I am trying to figure out how this Update statement should look. I think the quotes are in the wrong place.

Dim oleCommand = New OleDbCommand("Update requests Set technician ='" & tech.selecteditem.text & "','" comments ='" & comments.text & "' Where ticket='" & request.Querystring("id"))

 

[jzelhart]

I think it needs the following change.

Dim oleCommand = New OleDbCommand("Update requests Set technician ='" & tech.selecteditem.text & "', comments ='" & comments.text & "' Where ticket='" & request.Querystring("id")) & "'"

Hope everyone is having a great day!

Thanks - Jennifer