Mysql input too long..
#8

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, "", "");
Why you don't use mysql_format()
And yeah if you really have some big ass queryes you can split them up. Like half of the data in one query then TQUERY and the rest of after that TQUERY...
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)