Jochen
If you're trying to join tables in the query, one workaround is to use
nested queries. This is *not* a recommended way of performing a join, but
where needs must... For example, this CMP finder method joins tables
CollabObjectLog and ContributionLog, whose keys have a one-to-one
relationship. From ContributionLogEntry.properties:
db.Finder.findByCollaborationObjectGUID where ContributionLogKey=(select
CollaborationObjectLogKey from CollabObjectLog where GUID=?)
This will find the ContributionLogEntry record whose associated
CollabObjectLog record has the specified value for GUID. A half-decent DBMS
will optimize this down to a proper inner join anyway.
Joe
-----Original Message-----
From: Jochen Vastmans [SMTP:[EMAIL PROTECTED]]
Sent: Monday, February 21, 2000 8:12 PM
To: [EMAIL PROTECTED]
Subject: SQL Query - Problem
Hi,
Can you change sql queries in JOnAS?
I am using JOnAS 1.5 and i work with CMP beans.
You only can change the sql query from WHERE...
In JOnAS al sql queries are like:
SELECT id FROM table WHERE table.name='bla'
Can you change the part after SELECT, like in this case only the column id
will be returned.
I want to add some columnnames.
Is it possible to change that?
Best Regards
Jochen Vastmans
[EMAIL PROTECTED]
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
