Re: Question about DIH execution order

2009-11-02 Thread Fergus McMenemie
Bertie, Not sure what you are trying to do, we need a clearer description of what "select *" returns and what you want to end up in the index. But to answer your question The transformations happen after DIH has performed the SQL statement. In fact the rows output from the SQL command are assigne

Re: Question about DIH execution order

2009-11-02 Thread Bertie Shen
Hi Noble, I tried to understand your suggestions and played different variations according to your reply. But none of them work. Can you explain it in more details? Thanks a lot! BTW, do you mean your solution as follows? But 1) T

Re: Question about DIH execution order

2009-11-01 Thread Noble Paul നോബിള്‍ नोब्ळ्
On Sun, Nov 1, 2009 at 11:59 PM, Bertie Shen 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

Question about DIH execution order

2009-11-01 Thread Bertie Shen
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