Hello,

I am fairly new to JavaScript and to SQL, and I seem to be having some trouble with the following code.

var mySQL = "UPDATE Playerlist SET PlayerHP = PlayerHP + 10, PlayerGold = Gold WHERE PlayerNumber = MaxPlayerNumber";
adoConnection.Execute (mySQL);

Playerlist is the name of my table.
PlayerHP and PlayerGold are names of columns in the table.
Gold and MaxPlayerNumber are variables containing integers.

When I run the code I get an error telling me that there are too few parameters, but it seems to work fine if I enter in numbers in place of the variables.

I tried checking the spelling and it all seems to be correct.

Does anyone have any ideas?

Thanks in advance for any assistance you guys can give.

Hii dcameron!!

Check your -->PlayerGold = Gold to PlayerGold = 'Gold'

i.e.

var mySQL = "UPDATE Playerlist SET PlayerHP = PlayerHP + 10, PlayerGold = 'Gold' WHERE PlayerNumber = MaxPlayerNumber";
adoConnection.Execute (mySQL);

hope this will help you

Cheers :)

vinod