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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to