mysql_function_query
#1

Hey guys, so whenever I got my code like this.
pawn Code:
mysql_function_query(g_Handle, "CREATE TABLE IF NOT EXISTS `users` ( \
        `id` int(11) NOT NULL AUTO_INCREMENT, \
        `name` varchar(24) NOT NULL, \
        `pass` varchar(129) NOT NULL, \
        `health` float NOT NULL, \
        `X` float NOT NULL, \
        `Y` float NOT NULL, \
        `Z` float NOT NULL, \
        `A` float NOT NULL, \
        `interior` int(2) NOT NULL, \
        `vw` int(11) NOT NULL, \
        `skin` int(3) NOT NULL, \
        `banned` int(3) NOT NULL, \
        `primary` int(3) NOT NULL, \
        `primaryammo` int(5) NOT NULL, \
        `secondary` int(3) NOT NULL, \
        `secondaryammo` int(5) NOT NULL, \
        PRIMARY KEY (`id`) \
    )"
, false, "SendQuery", "");
I get: error 075: input line too long (after substitutions)

Whenever I use strcat like this
pawn Code:
strcat(qry1,"CREATE TABLE IF NOT EXISTS `users` ( \
        `id` int(11) NOT NULL AUTO_INCREMENT, \
        `name` varchar(24) NOT NULL, \
        `pass` varchar(129) NOT NULL, \
        `health` float NOT NULL, \
        `X` float NOT NULL, \
        `Y` float NOT NULL, \
        `Z` float NOT NULL, \
        `A` float NOT NULL, "
);
    strcat(qry1,"`interior` int(2) NOT NULL, \
        `vw` int(11) NOT NULL, \
        `skin` int(3) NOT NULL, \
        `banned` int(3) NOT NULL, \
        `primary` int(3) NOT NULL, \
        `primaryammo` int(5) NOT NULL, \
        `secondary` int(3) NOT NULL, \
        `secondaryammo` int(5) NOT NULL, PRIMARY KEY (`id`))"
, false, "SendQuery", "");
    mysql_function_query(g_Handle, qry1);
I get: error 017: undefined symbol "mysql_function_query"

Please note that it works and compiles fine when I do it like this.

pawn Code:
mysql_function_query(g_Handle, "CREATE TABLE IF NOT EXISTS `users` ( \
        `id` int(11) NOT NULL AUTO_INCREMENT, \
        `name` varchar(24) NOT NULL, \
        `pass` varchar(129) NOT NULL, \
        `health` float NOT NULL, \
        `X` float NOT NULL, \
        `Y` float NOT NULL, \
        `Z` float NOT NULL, \
        `A` float NOT NULL, \
        `interior` int(2) NOT NULL, \
        `vw` int(11) NOT NULL, \
        `skin` int(3) NOT NULL, \
        PRIMARY KEY (`id`) \
    )"
, false, "SendQuery", "");
Left out 5 of the lines.
Reply


Messages In This Thread
mysql_function_query - by TonyII - 03.01.2015, 10:47
AW: mysql_function_query - by CutX - 03.01.2015, 10:55
Re: mysql_function_query - by TonyII - 03.01.2015, 11:00
AW: Re: mysql_function_query - by CutX - 03.01.2015, 11:03
Re: AW: Re: mysql_function_query - by CrazyChoco - 03.01.2015, 11:07
AW: Re: AW: Re: mysql_function_query - by CutX - 03.01.2015, 11:17
Re: mysql_function_query - by TonyII - 03.01.2015, 11:24
AW: Re: mysql_function_query - by CutX - 03.01.2015, 11:29
Re: mysql_function_query - by TonyII - 03.01.2015, 11:32
Re: mysql_function_query - by CoaPsyFactor - 03.01.2015, 11:43

Forum Jump:


Users browsing this thread: 1 Guest(s)