On Thu, 17 Oct 2002 03:36, you wrote: > Actually, I have no street table (and don't want > one)...I actually want to figure out how to get > a list of streets out of the location table... > > (If I had a street table, you are correct, it's > easy to do...do you have a solution when there > is not a street table)?
Hi Scott, Unfortunately, a Torque business object (in your case Location) is always populated with all columns/attributes of the table it maps to. This means that you can't work with partially populated business objects in Torque, so you often have to use either Village or JDBC for low level SQL... unless I am misunderstanding your question. However, OJB supports all this kind of stuff (ie: lazy materialization, proxies etc.), so you might want to evaluate OJB for your application. Torque doesn't solve all problems, so in practice you will end up writing some Village or JDBC code if you decide to use Torque. Regards, -- Rodney -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
