SA-MP Forums Archive
Query String - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Query String (/showthread.php?tid=221739)


Query String - Antonio [G-RP] - 06.02.2011

I've no idea whats wrong here.

pawn Код:
format(query, sizeof(query), "INSERT INTO `teleports` (SQLid, pos_x, pos_y, pos_z, int, vw, topos_x, topos_y, topos_z, toint, tovw) VALUES (null, %f, %f, %f, %d, %d, %f, %f, %f, %d, %d)", \
    pos_x, pos_y, pos_z, int, vw, topos_x, topos_y, topos_z, toint, tovw);
Код:
Error (0): Could not execute query. 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, vw, topos_x, topos_y, topos_z, toint, tovw) VALUES (null, 246.446166, 87.42' at line 1.


Re: Query String - [L3th4l] - 06.02.2011

Increase the size of 'query'

Re: Query String - Antonio [G-RP] - 06.02.2011

I did from 250 to 500, and it still didn't work. Would it really be so much bigger?

Re: Query String - Antonio [G-RP] - 06.02.2011

I've increased it to 1000 and I still get the same error.