Retrieving large list of id objects problem

[Felipe Ramos <fr...@tissat.es>]

I'm working with Torque 3.1 and I need to catch a List of ids of a table 
of customers ( I only need their ids). That table can have thousands of 
rows, and each row has  a lot of columns, so using Criteria to catch a 
list of thousands of customer objects is very inefficient and very, 
very,  slow.  I only need the ids of a query like this "select id from 
customer where money>500" .

How ( and Where ) can I develop a method that execute that query and 
return only a list of ids without having to retrieve a list of objects?
Which is the best solution?

Thank you very much!


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org