[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