near "%": syntax error: SQLite Error

near "%": syntax error: SQLite Error - 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)
+--- Thread: near "%": syntax error: SQLite Error (/showthread.php?tid=606023)

near "%": syntax error: SQLite Error - DarkLored - 28.04.2016

So I have worked for a good hour on completing a vehicle dealership system for my gamemode and I found stumbled upon an issue that I do not know what went wrong with the query itself. Help would be appreciated.

Код:

INSERT INTO vehicles (vID, vModelID, vOwner, vPosX, vPosY, vPosZ, vPosA, vPlates, vColor1, vColor2, vInterior, vWorld, vValue, vLock, vAlarm) VALUES (%d, %d, %d, %f, %f, %f, %f, '%s', %d, %d, %d, %d, %d, %d, %d)

It results in an error with the percentage sign and I don't really know why.

Re: near "%": syntax error: SQLite Error - iggy1 - 28.04.2016

Quote:

Originally Posted by DarkLored

So I have worked for a good hour on completing a vehicle dealership system for my gamemode and I found stumbled upon an issue that I do not know what went wrong with the query itself. Help would be appreciated.

Код:

INSERT INTO vehicles (vID, vModelID, vOwner, vPosX, vPosY, vPosZ, vPosA, vPlates, vColor1, vColor2, vInterior, vWorld, vValue, vLock, vAlarm) VALUES (%d, %d, %d, %f, %f, %f, %f, '%s', %d, %d, %d, %d, %d, %d, %d)

It results in an error with the percentage sign and I don't really know why.

Some of your column names contain keywords: vInterior. It's not allowed: http://www.sqlite.org/lang_keywords.html

I believe you can wrap them in grave accents (`) and they will be recognized as identifiers.

EG,

Код:

INSERT INTO vehicles (..., `vInterior`, ...

Re: near "%": syntax error: SQLite Error - BloodyRP - 28.04.2016

PHP код:



INSERT INTO vehicles (`vID`,`vModelID`, `vOwner`, `vPosX`, `vPosY`, `vPosZ`, `vPosA`, `vPlates`, `vColor1`, `vColor2`, `vInterior`, `vWorld`, `vValue`, `vLock`, `vAlarm`) VALUES (`%d`, `%d`, `%d`, `%f`, `%f`, `%f`, `%f`, `%s`, `%d`, `%d`, `%d`, `%d`, `%d`, `%d`, `%d`)

Re: near "%": syntax error: SQLite Error - DarkLored - 28.04.2016

I end up with this error

Код:

datatype mismatch: INSERT INTO vehicles (`vID`,`vModelID`, `vOwner`, `vPosX`, `vPosY`, `vPosZ`, `vPosA`, `vPlates`, `vColor1`, `vColor2`, `vInterior`, `vWorld`, `vValue`, `vLock`, `vAlarm`) VALUES ('%d', '%d', '%d', '%f', '%f', '%f', '%f', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d')

Query that was used

pawn Код:

INSERT INTO vehicles (`vID`,`vModelID`, `vOwner`, `vPosX`, `vPosY`, `vPosZ`, `vPosA`, `vPlates`, `vColor1`, `vColor2`, `vInterior`, `vWorld`, `vValue`, `vLock`, `vAlarm`) VALUES ('%d', '%d', '%d', '%f', '%f', '%f', '%f', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d')

This issue has something more to it, I tried to isolate vInterior in the query from everything else and it worked with the method you have told me to use but when I put them all together it doesn't.