(Coemu V2) What is wrong with that damn command

[samehvan]

hello all

anyone have some exp with mysql would have a look and tell me what is wrong with that **** command

MySqlCommand Cmd = new MySqlCommand("UPDATE `guilds` SET `Wins` = " + TheGuild.Wins + ", `HoldingPole` = " + TheGuild.HoldingPole + ", `Bulletin` = " + TheGuild.GBull + ", `Enemies` = " + AllEnemies + ", `Allies` = " + AllAllies + ", `Fund` = " + TheGuild.GFund + ", `Members` = " + TheGuild.GMems.Count + " WHERE `GuildID` = " + ID, DatabaseConnection.NewConnection());

and here is the error msg

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near Enemies=0,Allies=2,Fund=5000,Members=1, where GuildId=1 Line 1

and the same msg appears once be4 when i tried to save the player spouse

[tribalost]

WHERE `GuildID` = " + ID + ";", DatabaseConnection.NewConnection());

[samehvan]

Originally Posted by tribalost

WHERE `GuildID` = " + ID + ";", DatabaseConnection.NewConnection());

no ,that should give a syntax error , and notice that it already does the first part successfully , it saves the wins,holdingpole and Bulletin

[kinshi88]

If it's a string your writing to the Sql, you have to add ' ' s around it.

So like:

`Bulletin` = [B][U]'[/U][/B]" + TheGuild.GBull + "[B][U]'[/U][/B]

[samehvan]

Originally Posted by kinshi88

If it's a string your writing to the Sql, you have to add ' ' s around it.

So like:

`Bulletin` = [B][U]'[/U][/B]" + TheGuild.GBull + "[B][U]'[/U][/B]

#solved thanks for your help
Request close or delete

[tanelipe]

#Closed as requested.