Executing query problem - 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: Executing query problem (/showthread.php?tid=493892)

---

Executing query problem - Riwerry - 10.02.2014

Hello guys
Im using latest R36-2 of BlueG mysql plugin when I am selecting name from DB it not working when I use %e placeholder for escaped string, but when I use %s it works: Here is mysql debug

Here you can see it executed query successfuly, it got player name and stored it to %s placeholder

mysql_tquery - connection: 1, query: "SELECT * FROM `Users` WHERE `Name` = 'Sanios' LIMIT 1", callback: "OnAccountCheck", format: "i"

Here you can see it didnt execute query successfuly, it didnt got player name. Here im using %e to escape string

mysql_tquery - connection: 1, query: "SELECT * FROM `Users` WHERE `Name` = 'e' LIMIT 1", callback: "OnAccountCheck", format: "i"

---

Re: Executing query problem - PowerPC603 - 10.02.2014

Did you use mysql_format?

I had the same problem and I used the normal format instead of mysql_format.
My names were all "e"s instead of the real names.

The normal format function doesn't recognise "%e" and turns it into "e".

---

Re: Executing query problem - Riwerry - 10.02.2014

Yeah, that was it. Already solved it maddinator helped

But thanks.

---