SQL (error #1064)
#1

Been double-checking this for a while, can't figure out what's wrong in this query. Can anyone check it out and tell me what's wrong?


pawn Код:
format(query,sizeof(query),"INSERT INTO texts (ID,distance,x,y,z,xx,yy,zz,text,vw,int,vww,intt) VALUES (%i,%i,%f,%f,%f,%f,%f,%f,'%s',%i,%i,%i,%i)",
        id,T[id][dDistance],T[id][tX],T[id][tY],T[id][tZ],T[id][tXx],T[id][tYy],T[id][tZz],T[id][xText],T[id][xVW],T[id][xInt],T[id][xVWw],T[id][xIntt]);
        mysql_tquery(mysql,query,"testtest");
Output:
pawn Код:
INSERT INTO texts (ID,distance,x,y,z,xx,yy,zz,text,vw,int,vww,intt) VALUES (1,50,1555.216796,-1726.411987,13.546875,0.000000,0.000000,0.000000,'Test',0,0,0,0)
Error:
pawn Код:
[20:32:25] [ERROR] CMySQLQuery::Execute[testtest] - (error #1064) 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 'int,vww,intt) VALUES (1,10,1559.668945,-1727.496459,13.382812,0.000000,0.000000,' at line 1
Thanks.
Reply


Messages In This Thread
SQL (error #1064) - by DaniceMcHarley - 21.07.2015, 18:12
Re: SQL (error #1064) - by DaniceMcHarley - 21.07.2015, 22:01
Re: SQL (error #1064) - by Crystallize - 21.07.2015, 22:03
Re: SQL (error #1064) - by Krokett - 21.07.2015, 22:11
Re: SQL (error #1064) - by Evocator - 22.07.2015, 07:19
Re: SQL (error #1064) - by mamorunl - 22.07.2015, 08:18
Re: SQL (error #1064) - by DaniceMcHarley - 22.07.2015, 13:21

Forum Jump:


Users browsing this thread: 1 Guest(s)