|
Veteran Member
Join Date: Dec 2008
Location: Portugal
|
06-22-2009
, 20:30
Re: SQL Error when name contains apostrophe
|
#8
|
Quote:
Originally Posted by Spunky
Code:
#include <amxmodx> #include <sqlx> new Handle:g_hSQLTuple
public plugin_init() { register_plugin("SQL Syntax Error", "1.0", "Spunky") g_hSQLTuple = SQL_MakeDbTuple("localhost", "root", "test", "arp") new szQuery[256] formatex(szQuery, 255, "CREATE TABLE IF NOT EXISTS synerrorlolar (Proved VARCHAR(20), IT VARCHAR(20), UNIQUE KEY (Proved))")
SQL_ThreadQuery(g_hSQLTuple, "fnQueryHandle", szQuery) new szName[32] szName = "Spunky 'lolar' Test" formatex(szQuery, 255, "INSERT INTO synerrorlolar VALUES ('%s', 'You fail.')", szName) SQL_ThreadQuery(g_hSQLTuple, "fnQueryHandle", szQuery) } public fnQueryHandle(FailState, Handle:hQuery, szError[], iErrorCode, iData[], iDataSize) { if (FailState == TQUERY_CONNECT_FAILED) &nb sp;set_fail_state("Could not connect to SQL database!") else if (FailState == TQUERY_QUERY_FAILED) &nb sp;set_fail_state("Query failed to execute!") return PLUGIN_CONTINUE }
|
Make this:
PHP Code:
formatex(szQuery, 255, "INSERT INTO synerrorlolar VALUES ('%s', 'You fail.')", szName)
PHP Code:
formatex(szQuery, 255, "INSERT INTO synerrorlolar VALUES (^"%s^", 'You fail.')", szName)
__________________
|
|
|
|