hi mark,

ojb does not split large IN-statements except when using prefetched
relationships.

hth
jakob

----- Original Message -----
From: "Mark Rowell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 11:25 AM
Subject: Large in satements


> Hi
>
> I have a need for large in statements in certain queries and I notice that
> OJB (0.9.6) does not
> do anything like splitting them up into chunks manageable by the
underlying
> DBMS; hence I have to di it myself
> on an as needed basis. An alternative to a large in statement is using
> temporary tables to join to
> - is there anyway of using these in OJB?
>
> Thanks
>
> Mark Rowell
>
> ----------------------------------------------------------------
> Mark Rowell
> CreditTrade
>
> T: +44 (020) 7400 5078
> M: mailto:[EMAIL PROTECTED]
>
> CreditTrade Limited is regulated by the FSA. (c) CreditTrade 2002. All
rights reserved. The information and data contained in this email is
provided for the information purposes of the addressee only and should not
be reproduced and/or distributed to any other person. It is provided without
any warranty whatsoever and unless stated otherwise consists purely of
indicative market prices and other information.
>
> Any opinion or comments expressed or assumption made in association with
the data or information provided in this email is a reflection of
CreditTrades judgement at the time of compiling the data and is subject to
change. CreditTrade hereby makes no representation and accepts no
responsibility or liability as to the completeness or accuracy of this
email.
>
> The content of this email is not intended as an offer or solicitation for,
or recommendation of, the purchase or sale of any financial instrument, or
as an official confirmation of any transaction, and should not be construed
as investment advice.
>
> --
> To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to