I cannot see a nice solution to my problem, I would like to do a (PersistenceBroker API) QueryByCriteria that uses where-clauses on two tables that have no relations to each other.
ex.: 2 tables
TAB_A ( ID_A, VALUE_A ) and TAB_B ( ID_B, VALUE_B )
now i need a query like:
SELECT ID_A, VALUE_A from TAB_A, TAB_B WHERE ID_B = 1 AND TAB_B.VALUE LIKE '%,'||TAB_A.ID_A||',%'
I must use a QueryByCriteria and not a QueryBySQL because I have to add several other where clauses over mutliple join paths.
This is actually an (ugly, but fast) workaround for the Sybase IN-limit of 250 values, since the SqlInLimit trick OJB uses doesn't work on Sybase. (Using a 'real' RDBMS instead of Sybase is also not an alternative, sorry)
Any help would be greatly appreciated, thanks danilo
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
