MySQL Error
#1

pawn Код:
MySQL retourneerde: Documentatie
#1064 - 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 '(0, 2 Room Apartment, 1090.1619, -1785.1078, 13.6468, 2496.049804, -1695.238159,' at line 2
What's the problem?
Reply
#2



The message you have entered is too short. Please lengthen your message to at least 8 characters.
Reply
#3

post the code.
Reply
#4

pawn Код:
SQL-query:

--
-- Gegevens worden uitgevoerd voor tabel `server_houses`
--
INSERT INTO `server_houses` ( `ID` , `Description` , `EnterX` , `EnterY` , `EnterZ` , `ExitX` , `ExitY` , `ExitZ` , `Int` , `Vir` , `Level` , `Owned` , `Owned` , `Cost` , `Locked` , `Vehicle` , `Vcolor1` , `Vcolor2` , `Paintjob` , `VehX` , `VehY` , `VehZ` , `VehA` , `Plate` , `Garbage` , `NotUsed` )
VALUES ( 0, 2Room Apartment, 1090.1619, - 1785.1078, 13.6468, 2496.049804, - 1695.238159, 1014.742187, 3, 1, 5, 0, The State, 100000, 1, 516, 1, 1, 255, 1896.000000, - 2145.000000, 13.000000, 179.000000, Housecar, 0, 0 ) ;

MySQL retourneerde: Documentatie
#1064 - 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 'Room Apartment, 1090.1619, -1785.1078, 13.6468, 2496.049804, -1695.238159, 1014.' at line 2
Reply
#5



The message you have entered is too short. Please lengthen your message to at least 8 characters.
Reply
#6

use the string ' '

Код:
VALUES(0, '2Room Apartment', 10..
Reply
#7

FIXED THX.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)