db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tomasz Dreßler <tdr...@terragate.net>
Subject deep collection possible?
Date Sun, 29 Feb 2004 22:26:04 GMT
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message