Take a look at how the BaseXXXPeer do joing. If you build your OM with the complexObject (not sure if that is the setting) then you can see how the built in ones work, and just duplicate that.
Eric -----Original Message----- From: Tom Huybrechts [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 1:52 PM To: [EMAIL PROTECTED] Subject: Doing JOINs with BasePeer Hello, I'm trying to do a JOIN over multiple tables, and extract data from columns in all the tables involved. If i'm not mistaken, I can't do xxxPeer.doSelect(criteria), because then I can only access the columns of the xxx table. However, if I do BasePeer.doSelect, I get a List of Records that contains the right information. But when I try to access the Values in such a record, I have a problem. e.g. record.getValue(xxxPeer.ID) gives a DataSetException saying column 'ID' cannot be found. record.getValue("ID") does work and record.getValue(1) does too. Am I doing something wrong ? Is there an other way to do this ? Tom -- ----------------------------------------------------- Tom Huybrechts * Tel: 016/32.78.23 Dept. of Computer Science * Fax: 016/32.79.96 Katholieke Universiteit Leuven * GSM: 0497/92.37.49 *********** http://www.cs.kuleuven.ac.be ************ -- 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]>
