revDataFromQuery : size limit of mySQL query ?

[jbv at souslelogo.com]

Hi list,

Does anyone know if there is a limit in the length of the sql query
when using revDataFromQuery ?
According to what I found on the web, there doesn't seem to be
any problem on mySQL side (default value is apparently 1 Mb),
but I was more concerned by a possible buffer between LC and
mySQL where the query could be truncated...

Furthermore, I am fully aware that very long queries are hard
to maintain and might lead to slow execution...
What I have in mind in some rather simpler stuff like :
SELECT name FROM myDB WHERE name != 'John' AND name != 'Ted'...
where the list of names can be quite long...

Thanks,
jbv