So basically I’m wanting to join multiple queries into 1 query. After failing for a while I created a very simple test query and it also seems to fail.I created the test to simply try executing the query when it’s stored inside a variable, I’ve dumped the variable to see it’s contents and all seems fine in that regard:
For example, this works fine:
DB.Query(“UPDATE testable SET value=value+1 WHERE steamid =”…sql.SQLStr(v:SteamID())…";")
But when trying to execute the query in this manner it doesn’t seem to update the values, however no errors are appearing either on the gmod server or the mysql server.
xquery = “UPDATE testable SET value=value+1 WHERE steamid =”…sql.SQLStr(v:SteamID())…";"
print of xquery:
I’ve received no errors either on the garrysmod server or the mysql server so im a bit stumped. Any ideas?