1) There is an entry in the wiki in the section "Frequently asked
Questions" which describes how to execute a "count(*) from table where..."
using criteria without explicitly creating the statement.
2) As far as I know, subselects are not supported by criteria, so I guess
you will either have to use BasePeer.executeStatement(String query) and
construct the query by hand, or first do the subselect and then insert the
results in another criteria using criteria.addIn()
Hope that helps,
Thomas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]