On 13.03.2010, at 08:01, blargy wrote: > > I was actually able to accomplish (althought not pretty) what I wanted using > a regex transformer. > > <entity name="item" > transformer="RegexTransformer" > query="select *, 'valueA, valueB' values from items"> > <field column="myMultiValueField" sourceColName="values" splitBy=","/> > </entity>
Nice approach. In MySQL you also have a handy function that might come into play in your use case: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat This lets you do a group by and then concatenate all the values in the group into a string. regards, Lukas Kahwe Smith m...@pooteeweet.org
