Ok. If i understand the documentation right it must work with that. Please test
it.
# $c->add(TableI18nPeer::CULTURE, $culture);
$default_culture = sfConfig::get('sf_i18n_default_culture');
$subSelect = TableI18nPeer::CULTURE." = CASE WHEN (SELECT i18n.ID FROM
".TableI18nPeer::TABLE_NAME." as i18n WHERE i18n.CULTURE='".$culture."' AND
i18n.ID = ".TablePeer::ID.") THEN '".$culture."' ELSE '".$default_culture."')";
$c->add(TableI18nPeer::CULTURE, $subSelect, Criteria::CUSTOM);
Thanks.
gordon
-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[EMAIL PROTECTED] Im Auftrag von
Timu EREN
Gesendet: Sonntag, 29. April 2007 02:59
An: [email protected]
Betreff: [symfony-devs] Re: AW: [symfony-devs] Re: patch for i18n tables
Hi,
This is not work with pgsql
Perşembe 26 Nisan 2007 tarihinde, Franke Gordon şunları yazmıştı:
> I have test it only with a mysql ;(
>
> My code:
> # $c->add(TableI18nPeer::CULTURE, $culture);
> $default_culture = sfConfig::get('sf_i18n_default_culture');
> $subSelect = TableI18nPeer::CULTURE." = IF((SELECT i18n.ID FROM
> ".TableI18nPeer::TABLE_NAME." as i18n WHERE
> i18n.CULTURE='".$culture."' AND i18n.ID = ".TablePeer::ID."),
> '".$culture."', '".$default_culture."')";
> $c->add(TableI18nPeer::CULTURE, $subSelect, Criteria::CUSTOM);
>
>
> greetings
> Gordon
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[EMAIL PROTECTED]
> Im Auftrag von Fabien POTENCIER Gesendet: Donnerstag, 26. April 2007
> 10:12
> An: [email protected]
> Betreff: [symfony-devs] Re: patch for i18n tables
>
>
> To be included, you need to have a patch that works with every db
> supported by Propel and symfony.
>
> Fabien
>
> Franke Gordon wrote:
> > Hello,
> >
> >
> >
> > many peopel hast he problem that he get a empty database result if
> > no translation data fort he record exist. i have modify/add
> > (doSelect|doSelectOne|retrieveByPk)WithI18n functions. It makes a
> > subselect and check if the culture exist if not it use the default
> > culture.
> >
> >
> >
> > So my questions:
> >
> > Can i add this to the propel generator files?
> >
> > And with a optional parameter or per default?
> >
> >
> >
> > What you think about that?
> >
> >
> >
> >
> >
> > greetings
> >
> > Gordon
>
>
--
Saygılar && İyi çalışmalar
Timu EREN (a.k.a selam)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-devs?hl=en
-~----------~----~----~----~------~----~------~--~---
