SQL update: Expected end of statement

[rbuaoka]

I just joined this forum so I am not sure if this topic has already been covered in previous posts.

I am trying to write code for table update in my web app. I keep getting the following error:

Source line: Set Poll = "&p_poll&", Result = "&p_result& "
Description: Expected end of statement

Here is the code I am using:

Update tblCandidate
Set Poll = "&p_poll&", Result = "&p_result& "
where cadidateID = "&p_candidateID &";

can anyone shed some light?

Thanxs
rbuaoka