Mysql input too long..
#3

Quote:
Originally Posted by Metharon
Посмотреть сообщение
pawn Код:
format(szQuery, 500,"INSERT INTO `business` (ID, Ownable, Titlu, Detinator, Entrance, Interior, Type , Depozit, Price, PickupX, PickupY, PickupZ, EntranceX, EntranceY, EntranceZ, InteriorX, InteriorY, InteriorZ) VALUES ('%d','%d','%s','%s','%d','%d','%d','%d','%d','%f','%f','%f','%f','%f','%f','%f','%f','%f')", BID,Bizz[BID][BOwnable],Bizz[BID][Detinator],Bizz[BID][bEntrance],Bizz[BID][bInt],Bizz[BID][bType],Bizz[BID][BDeposit],Bizz[BID][BPret], Bizz[BID][PickupINT][0],Bizz[BID][PickupINT][1],Bizz[BID][PickupINT][2],Bizz[BID][Ext][0],Bizz[BID][Ext][1],Bizz[BID][Ext][2],Bizz[BID][Int][0],Bizz[BID][Int][1],Bizz[BID][Int][2]);
mysql_tquery(SQL, szQuery, "", "");
I tried strcat but still this error.. how can i make it work ?
pawn Код:
format(szQuery, 500, "INSERT INTO `business` (ID, Ownable, Titlu, Detinator, Entrance, Interior, Type , Depozit, Price, PickupX, PickupY, PickupZ, EntranceX, EntranceY, EntranceZ, InteriorX, InteriorY, InteriorZ) VALUES ('%d','%d','%s','%s','%d','%d','%d','%d','%d','%f','%f','%f','%f','%f','%f','%f','%f','%f')",
    BID,Bizz[BID][BOwnable],Bizz[BID][Detinator],Bizz[BID][bEntrance],Bizz[BID][bInt],Bizz[BID][bType],Bizz[BID][BDeposit],Bizz[BID][BPret], Bizz[BID][PickupINT][0],Bizz[BID][PickupINT][1],Bizz[BID][PickupINT][2],Bizz[BID][Ext][0],Bizz[BID][Ext][1],Bizz[BID][Ext][2],Bizz[BID][Int][0],Bizz[BID][Int][1],Bizz[BID][Int][2]);
    mysql_tquery(SQL, szQuery, "", "");
Try this.
e: You can also remove the ' for vars(%d), and the ` for tables/w.e (business)
Reply


Messages In This Thread
Mysql input too long.. - by Metharon - 23.01.2015, 10:30
AW: Mysql input too long.. - by Saize - 23.01.2015, 10:56
Re: Mysql input too long.. - by Kyance - 23.01.2015, 10:59
Re: Mysql input too long.. - by Metharon - 23.01.2015, 11:02
Re: Mysql input too long.. - by Metharon - 23.01.2015, 11:04
Re: Mysql input too long.. - by Ironboy - 23.01.2015, 11:06
Re: Mysql input too long.. - by Metharon - 23.01.2015, 11:27
Re: Mysql input too long.. - by Runn3R - 23.01.2015, 11:30

Forum Jump:


Users browsing this thread: 1 Guest(s)