[Solved] SQL Syntax Check

SkinnyBruv · **Author**

Code:

Format(query, sizeof(query), "UPDATE '%s' SET name='%s' WHERE steamid='%s'", tablePlayer, username, SID);
		//SQL_FastQuery(dbConn, query);
		SQL_TQuery(dbConn, SQL_dbDoNothing1, query);	// Send the Information off to the MySQL Database

Howdy guys, this has been driving me nuts!
Can you please check if my SQL Syntax is correct? i keep getting the error:
You have an error in your SQL syntax: check the manual that corresponds to your MariaDB server version for the right syntax to use near ''fngls' SET name='SkinnyBruv' WHERE steamid="SID" at line 1

shavit · 10-01-2016 , 02:53 Re: SQL Syntax Check

Code:

FormatEx(query, sizeof(query), "UPDATE %s SET name='%s' WHERE steamid='%s'", tablePlayer, username, SID);

try this

Drixevel · 10-01-2016 , 02:53 Re: SQL Syntax Check

Code:

UPDATE `%s` SET name='%s' WHERE steamid='%s'

Quote:

Originally Posted by shavit

Code:

FormatEx(query, sizeof(query), "UPDATE %s SET name='%s' WHERE steamid='%s'", tablePlayer, username, SID);

try this

Shanked

SkinnyBruv · 10-01-2016 , 03:09 Re: SQL Syntax Check

Whats difference between FormatEx and Format?

Cheers btw

Still got same problem

Same here:

Code:

stock bool SetTargetVIP(any:target)
{
	new String:query[255];
	new String:SID[70];
	
	GetClientAuthId(target, AuthId_Steam3, SID, sizeof(SID));
	GetConVarTable(TABLE_PLAYER);
	
	FormatEx(query, sizeof(query),  "UPDATE '%s' SET vip='0' WHERE steamid='%s'", tablePlayer, SID);//Gets GangCount (or largest gang id)
	//SQL_FastQuery(dbConn, query);
	SQL_TQuery(dbConn, SQL_dbDoNothing, query, target, DBPrio_High);
}

**Peace-Maker** · 10-01-2016 , 03:13 Re: SQL Syntax Check

It's not about the Format native used but about you putting quotes around the table name.

From the docs for FormatEx:

Quote:

This is the same as Format(), except none of the input buffers can overlap the same memory as the output buffer. Since this security check is removed, it is slightly faster.