The thing that is left off the addJoin example is how to reference the information from the left join. It may be beneficial to add information such as:
#foreach ($tuple in $tuples) $!tuple.leftJoinClassName.FieldName #end Elements in the rightJoin can be referenced in the less formal method: $tuple.FieldName —---> leftJoinClassName is implied. ------------------------------------------------------------- Darin Wilcox Web Engineer College of Nursing University of Utah 585-7332 >>> [EMAIL PROTECTED] 03/21/02 07:05PM >>> refer to http://jakarta.apache.org/turbine/turbine-2/howto/criteria-howto.html Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Darin Wilcox" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 9:01 AM Subject: SQL to Criteria Statement I have a statement that looks like this: select * from user_info, problem where user_info.user_id=problem.user_id_fk; I can't figure out how to conver this to Criterias used in Turbine. Can someone please help? Thanks, - Darin ------------------------------------------------------------- Darin Wilcox Web Engineer College of Nursing University of Utah 585-7332 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
