This requires some sort of Object-Relational modelling tool (what you're
trying to do is make one EJB out of more than one table).
This is being added to Orion at the moment and will be a part of the feature
set in the future.
For now, the quickest way is to either create two CMP beans and join them
through methods, eg a.getB() and b.getA() or use BMP with some OR software.
Cheers,
Mike
__
| | Director - The BookmarkBox P/L
| | http://www.bookmarkbox.com <http://www.bookmarkbox.com/>
|/\| Manage and share your bookmarks online!
Do you enjoy our service? Why not tell your friends about us?
http://www.bookmarkbox.com/email.cfm
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Alex Paransky
> Sent: Tuesday, 28 December 1999 12:37
> To: Orion-Interest
> Subject: Is there better control over the generated custom finder code
> in CMP?
>
>
> By default you get: SELECT <column> FROM <table>, you can also add a WHERE
> clause by playing with the <query></query>. I need to get the following
> format:
>
> SELECT <column> FROM <table1>, <table2> WHERE <table1>.<column> =
> <table2>.<column> and <table1>.<column> like $1
>
> Is this possible? In particular about the join from two tables?
> Are there
> any other tags I can add which will append something to the generated SQL
> but before the WHERE clause?
>
> Thanks.
> -AP_
>
>
>