> > > > > > But this still leaves me a "column ambiguously defined" error when using > > > addJoin(): > > > > > > crit.addJoin(TableAPeer.ColumnX, TableBPeer.ColumnG); > > > crit.addAscendingOrderByColumn(TableBPeer.ColumnQ); > > > crit.addAscendingOrderByColumn(TableBPeer.ColumnR); > > > List<TableB> tableBs = TableBPeer.doSelect(crit); > > > > > > generates > > > > > > SELECT <..TableB fields> FROM TABLE_A, TABLE_B, DBSCHEMA.TABLE_B > > > WHERE TABLE_A.COLUMN_X=TABLE_B.COLUMN_G ORDER BY TABLE_B.COLUMN_Q ASC, > > > TABLE_B.COLUMN_R ASC > > > > > > Where does the extra DBSCHEMA.TABLENAME come from?
I'm getting this again (wrote some more code like the above), this time without any addAscending...: Criteria crit = new Criteria(); crit.addJoin(TransactionPeer.ORDER_ID, OrderPeer.ID); crit.add(TransactionPeer.ACCT_ID, account.getID()); List<Order> orders = OrderPeer.doSelect(crit); generates SELECT <..ORDERS columns..> FROM TRANSACTION, ORDERS, DBSCHEMA.ORDERS, DBSCHEMA.TRANSACTION WHERE TRANSACTION.ORDER_ID=ORDERS.ID AND TRANSACTION.ACCT_ID= ? It seems that SQLBuilder.processJoins does not add the full table names, and SQLBuilder.processCriterions does. What am I doing wrong? Brendan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
