limit in length of sql string V4MD 4.3 on PC

[Ruslan Zasukhin]

On 11/24/09 9:19 PM, "Christian - ChrisKatDev.com"
<christian at chriskatdev.com> wrote:

> Hello Ruslan,
> 
> I have crash on pc, but not on mac, with a request very long (with very big
> "IN")
> => I have 95660 car in my request...
> 
> have you a limit ?
> 
> exemple : 
> "SELECT idPhoto FROM user_bloc_photos WHERE (idprojet = 2) AND (idPhoto IN (1,
> 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, ....., 15241,
> 15242))"

Please report this to mantis.

For now you can try remove spaces between numbers I think.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]