[Dbix-class] Advices needed on creating multilingual application

Mark Lawrence nomad at null.net
Wed Sep 19 14:03:40 GMT 2007


On Wed Sep 19, 2007 at 12:58:24PM +0200, Mark Lawrence wrote:

>     SELECT
>         t1.id,
>         CASCADE(t2.lang, t1.lang)   AS lang,
>         CASCADE(t2.title, t1.title) AS title,
>         CASCADE(t2.body, t1.body)   AS body,
>     FROM
>         entry AS t1
>     LEFT JOIN
>         entry_t AS t2
>     ON
>         t1.id = t2.transof AND t2.lang = 'ru'
>     ORDER BY
>         t1.ctime
>     LIMIT 5

My apologies, I got the function name wrong. There is no CASCADE, the
one I should have written is COALESCE.

Sorry for the confusion.

Mark.
-- 
Mark Lawrence



More information about the DBIx-Class mailing list