Scott, Thanks... I had not looked at the "exclude" methods but was just in the middle of creating a doSelectAll that merged the doSelectJoin's (as was done in the exclude methods. Glad to know I was headed in the right direction. And a related question... What about the case where I don't have foreign keys (not appropriate) and therefore can't rely on the auto-generated supporting peer getter/setter methods used in the doSelectJoin code. It also seems as though I'm supposed to use the BasePeer.doSelect() to perform selects when I don't intend to build corresponding OM objects. Often, I need to select specific columns from multiple disjoint tables via OUTER JOINs (which seems like (too) much extra work when trying to use the Criteria paradigm) My clients would like to create their own canned SQL procs (which preferably would be "Criteria procs"), but I can't provide a simple syntax for this. (Am I mistakenly thinking this more complicated than it is? - If not I'd love to see some example code.) Also, In my example case, I have added one additional table (Five) using the same primary key as the other tables, but without the foreign key constraint (thus, relying on an Outer JOIN). Since no corresponding access methods are auto-generated to handle it in the (One) peer class, I'm having difficulty including it in the doSelectAll method which attaches objects selected from the other tables into the (One) peer class. Looks like I'll have to make a secondary DB call per each row to get the related info I'll need :( (Is this really necessary?) - Is there any Torque/Criteria development effort going into emulating something done so simply with straightforward SQL ???? Wish I had the time and understanding to create a SQL to Criteria conversion utility.
Jeff Gehrung (Sr. Programmer Analyst) Holstein Association USA Brattleboro VT 05302 802.451.4146 [EMAIL PROTECTED] [EMAIL PROTECTED] I'm told "42" answers most ?s. --------------------------------- Do you Yahoo!? New DSL Internet Access from SBC & Yahoo!
