RE: Criteria.addSelectColumn problem

2008-08-22 Thread Thomas Fischer
> crit.add (c2, ) > crit.addSelectColumn (c3) > crit.setDistinct(); > Iterator results = t3Peer.doSelect(crit).iterator() > > would throw Exception at doSelect() because during the > populateObject(), it found only 1 column instead of all columns as > default to populate the data into it.

RE: Criteria.addSelectColumn problem

2008-08-22 Thread Manaster, Carl
Hi, Frank, > However, when I do it in Torque: > > crit.add (c2, ) > crit.addSelectColumn (c3) > crit.setDistinct(); > Iterator results = t3Peer.doSelect(crit).iterator() > > would throw Exception at doSelect() because during the > populateObject(), it found only 1 column instead of all >

Criteria.addSelectColumn problem

2008-08-22 Thread Frank Nguyen
I have 3 tables, t1, t2 and t3. t3 table is just a join-ref table of t1 and t2 in such a way that t3.c2 is ref index to t1.c1 and t3.c3 is a ref index to t2.c1 (t3.c1 is index for t3 table). Thus, table t3 has many records w/ same value in column 2 and 3. What I want is to select only rows fro

Re: how can i Insert data into multiple table at a time

2008-08-22 Thread Frank Nguyen
There is no difference b/w inserting into 1 table or multiple tables from a single form transaction. Read the tutorial at: http://db.apache.org/torque/releases/torque-3.1.1/user-guide.html If the second adding/inserting needs a ref index from previous inserted row, do something like: r1.save()