Hi, you could try using the executeQuery method in BasePeer, and then using the village api to get at the fields that you want. Have a look at the following for an example.
http://www.mail-archive.com/[email protected]/msg03372.html Jon -----Original Message----- From: Fedor Karpelevitch [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 15:17 To: 'Turbine Users List' Subject: RE: criteria hell In this case just do not use Criteria. Why do you need to? fedor. ------------------------------- The Joy of CVS > -----Original Message----- > From: Nick Pomfret [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 30, 2001 10:02 AM > To: Turbine Users List > Subject: criteria hell > > > Can someone please help me turn this SQL into a Criteria object? > > select > x.id, > max(x.some_column) > from > table_x x, > table_y y, > where > (y.blah < x.blah > or y.blah is null ) > and x.id = y.id > group by > x.id; > > -- > 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]> -------------------------------------------------- DISCLAIMER: This message contains proprietary information some or all of which may be confidential and/or legally privileged. It is for the intended recipient only who may use and apply the information only for the intended purpose. Internet communications are not secure and therefore the British Biotech group does not accept legal responsibility for the contents of this message. Any views or opinions presented are only those of the author and not those of the British Biotech group. If you are not the intended recipient please delete this e-mail and notify the author immediately by calling ++44 (0)1865 748747; do not use, disclose, distribute, copy, print or rely on this e-mail. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
