[Thomas.]

Hi all,

Currently I'm having some issues with a really long MySQL query.

At first I tried to put each statement on it's own line, like this:

Код:

format(query, sizeof(query), "UPDATE `example` SET
example  = 'foo',
example2 = '',
...

And so on

This resulted in a "error 037: invalid string (possibly non-terminated string)".

Then I tried to just put the whole query on 1 line, which caused it to be a very long line, with result "error 075: input line too long (after substitutions)".

How should I solve this problem?

Thomas