MySQL issue
#1

pawn Код:
format(szQuery, sizeof(szQuery), "INSERT INTO `Points` (`opCoX`, `opCoY`, `opCoZ`, `opCoA`) VALUES (%f, %f, %f, %f) WHERE `pID` = %d", positions[0], positions[1], positions[2], positions[3], id);
    mysql_function_query(dbHandle, szQuery, false, "thread_InsertPoint", "d", playerid);
I have this and get this error.
Код:
[17:05:44] [WARNING] CMySQLHandler::FreeResult() - The result is already empty.
[17:06:03] [ERROR] ProcessQueryThread(thread_InsertPoint) - 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 'WHERE (`pID` = 6)' at line 1 (error ID: 1064)
What's the correct syntax, if not WHERE `pID` = %d or WHERE (`pID` =%d)?
Reply


Messages In This Thread
MySQL issue - by BigGroter - 14.06.2013, 15:11
Re: MySQL issue - by LilBob - 14.06.2013, 15:36
Re: MySQL issue - by BigGroter - 14.06.2013, 15:40
Re: MySQL issue - by FunnyBear - 14.06.2013, 15:48
Re: MySQL issue - by BigGroter - 14.06.2013, 15:56
Re: MySQL issue - by InfiniTy. - 14.06.2013, 16:09
Re: MySQL issue - by BigGroter - 14.06.2013, 17:29

Forum Jump:


Users browsing this thread: 1 Guest(s)