Did not Work
Thank you for the suggestion Ray, but unfortunately it did not work. I have my name attribute hard coded to 'candidate' and the value hard coded to '1' now. The id is dynamic where I used a server behavior to assign the database id to the respective person.
I believe my error is in the MySQL statement. For whatever reason I cannot perform an update that searches for the where of the dynamic id.
I know this is not a MySQL forum, but here is the partial statement I am using in case you have a suggestion:
within an if statement for submit:
$query: "UPDATE candidates SET numberVotes=numberVotes+1 WHERE id=id";
QUESTION:
the original SQL statement that DW generated had numberVotes=%s. What does the %s stand for, as I could not see it repeated within the generated code.
Regardless of a new suggestion, thank you for your help.
Jon