On Wed, 3 May 2006 10:53:58 +0200, Bealach Na Bo wrote: Hi Bealach
> I agree, a Perl snippet to generate the scalar @names place holders > would probably push the query over max query size, as well as > various other name space limits. Probably a bad idea. I found with Postgres V 7 I had to limit the length of the SQL to avoid the error: 'expression too complex'. So I picked 2000 place holders at a time. MySQL handled up to 10,600 in one expression, so it was the difference in max sql length: Postgres => 32K chars, MySQL => 64K chars. But really all to long to be good style. -- Cheers Ron Savage, [EMAIL PROTECTED] on 4/05/2006 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company
