limit in length of sql string V4MD 4.3 on PC

[Bart Pietercil]

By the looks of it , I would think you can write the subselect with
idPhoto < 15241 ?

hth

Bart Pietercil
CTO Cognosis NV



On 24 Nov 2009, at 20:23, Ruslan Zasukhin wrote:

> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina