Hi Joerg, you might have a look at the underlying Village library used by Torque. Below you find a code snippet fro a JUNIT test using a prepared SELECT statement using Torque and Village.
Cheers, Siegfried Goeschl >>> Code Snippet >>> // Get a single product Product product = ProductPeer.retrieveByPK( this.productKey1 ); // Define all the columns we want to select CartorderposPeer.addSelectColumns( criteria ); // Add our criteria criteria.add( CartorderposPeer.PRODUCTID, product.getPrimaryKey() ); // Get a list of Village Records recordList = CartorderposPeer.doPSSelect( criteria ); // Convert them into Database classes cartOrderPosList = CartorderposPeer.populateObjects( recordList ); <<< Code Snippet <<< -----Original Message----- From: Rutzen, Joerg [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 5:44 AM To: '[EMAIL PROTECTED]' Subject: select only on column hi, is there a possibility to select only one column. if i code this ... Criteria crit = new Criteria(); crit.add( EinsatzAbPeer.NAME, "Meyer" ); try { list = EinsatzAbPeer.doSelect( crit ); ... the statement is actually about a the table. How do i have to change the doSelect , if i only want to have the NAME Regards J�rg --------------------------------------------------------------------- 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]
