deep collection possible?

[Tomasz Dre�ler]

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]