Re: weird happenings w/ pagination and useDbConfig

Found a workaround ... but still not sure why paginate won't recognize
the hasOne table from another db.

Here's what I had to add to the paginate array:

'joins' => array('JOIN db2.game_profiles AS GameProfile on User.id =
GameProfile.user_id'),

Weird.

On Jun 24, 11:28 pm, Cahlan <cah...@gmail.com> wrote:
> Hi all, I recently needed to split some of the tables in my app apart
> into two separate dbs. No problem, just set up two different
> connections in database.php and used "useDbConfig" to specify what
> tables go where.
>
> Seems to be working fine for the most part, but I have a pagination
> problem in an area that was working before.
>
> Model "User"(db1) hasOne "Demographic"(db1), "Profile"(db1),
> "GameProfile"(db2)
>
> When I try and paginate User and order by GameProfile.exp_points it
> says it can't find the column. Any ideas?
>
> Thanks in advance,
>
> Cahlan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---