On Sun, Nov 1, 2009 at 11:59 PM, Bertie Shen <bertie.s...@gmail.com> wrote:
> Hi folks,
>
> I have the following data-config.xml. Is there a way to
> let transformation take place after executing SQL "select comment from
> Rating where Rating.CourseId = ${Course.CourseId}"? In MySQL database,
> column CourseId in table Course is integer 1, 2, etc;
> template transformation will make them like Course:1, Course:2; column
> CourseId in table Rating is also integer 1, 2, etc.
>
> If transformation happens before executing "select comment from Rating
> where Rating.CourseId = ${Course.CourseId}", then there will no match for
> the SQL statement execution.
>
> <document>
> <entity name="Course" transformer="TemplateTransformer" query="select *
> from Course">
> <field
> column="CourseId" template="Course:${Course.CourseId}" name="id"/>
> <entity name="Rating" query="select comment from Rating where
> Rating.CourseId = ${Course.CourseId}">
> <field column="comment" name="review"/>
> </entity>
> </entity>
> </document>
>
keep the field as follows
<field
column="TmpCourseId" name="CourseId"
template="Course:${Course.CourseId}" name="id"/>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com
