Hi Tomasz,
There should be a protected method in your BaseServerPeer.java called doSelectJoinFile(crit) that will fill in the File objs in the Servers. You'll need to make a public wrapper method for it in ServerPeer.java, so you can then call ServerPeer.doSelectJoinFile(crit). Dale On Sun, 29 Feb 2004 23:26:04 +0100, "Tomasz Dre�ler" <[EMAIL PROTECTED]> said: > Hi! > I have two tables 'server' and 'file'. > Without torque I used the query: > SELECT server.serverAdress, server.serverName, file.filePath, > file.fileName > FROM server, file > WHERE server.serverAdress=file.serverAdress > AND file.fileName like '%search%' > > I wish that ServerPeer.doSelect(crit) returns a collection of servers. > Each server should include the file objects belong to that server. > > I just get the server without the file objects. > > Thanks, > Tomasz Dre�ler > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
