on 5/16/2000 7:21 PM, John McNally <[EMAIL PROTECTED]> wrote:
> I think this can be solved two ways. If you are selecting
> ProjectPeer.PROJECT_ID, the join should be automatic, so I assume you are
> not selecting it. You can either add it to the select columns or try
Actually, I am selecting that....there is a:
criteria.addSelectColumn(ProjectPeer.PROJECT_ID);
The problem is not with the join though...
As I said before, the join is being made properly...the problem is the
single '' around the right hand side of the join...please look at that SQL I
posted in my first message.
> selectCriteria.add("forcing a join", (Object)(ProjectPeer.PROJECT_ID + "=" +
> ProjectVisitorPeer.PROJECT_ID), Criteria.CUSTOM );
>
> A bit ugly, but currently, this is the way to get any sql you want into the
> where clause.
That won't work because the join IS being made properly...the problem is the
'' around it...for this kludge to work, I would have to remove the above
criteria line and that would be bad.
-jon
--
Java Servlet Based - Open Source | Collab.Net
Bug/Issue Tracking System | now hiring smart people
<http://scarab.tigris.org/> | <http://Collab.Net/jobs/>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
