YOu can always use $this->Language->sql('select myfields from
`languages` left join `packages` on id=id') (obvioously not complete)
and build your own query to return the nested results.
If that doesnt answer than I guess I dont understanf the question.
Dropboxes are pretty standard and you should not eed to write your own
html.
On Jun 5, 6:08 pm, Hans Allis <[EMAIL PROTECTED]> wrote:
> Hi,
>
> While trying to build a copy of an existing application (which we
> developed w/o a framework) using CakePHP, I've run into a small issue
> regarding left outer joins in an HABTM relationship.
>
> In our application, users can add/edit/delete packagings and
> languages. Users can also store translations for each type of
> packaging in each of the available languages. I want to present a
> simple list of languages with an input box for each one to enter a
> translation. To do this, I've created a languages_packagings table
> which consists of four columns: id int, language_id int, packaging_id
> int and translation varchar.
>
> The Language and Packaging class point to each other using the
> $hasAndBelongsToMany variable. Now, when I find() a specific
> packaging, I'll also get related Language records which in turn each
> contain the relevant LanguagePackaging record. The problem I'm having
> is that newly added languages are not included. This is perfectly
> logical behavior, but I'd like to be able to somehow specify that I
> want a left outer join between the languages and languages_packagings
> tables.
>
> Is there a behavior that allows me to do just that ? I could of course
> pull in the languages separately, but I'd love to be able to use $form->input
> ("Language.".$key.".LanguagesPackaging.translation") instead of
>
> writing my own HTML. When I sabotage cake/libs/model/datasources/
> dbo_source.php to perform outer joins, the rest of the code works
> nicely, but this is of course not the right way to do this.
>
> Hope I'm missing something obvious here, but thus far I haven't been
> able to figure out a clean solution to this.
>
> Kind regards,
>
> Hans
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
