Did you try like:
> var $paginate = array ('order' => 'Pages.index');
Andras Kende
On Sep 23, 2009, at 12:33 AM, mig_akira wrote:
>
>
> Hello everyone!
>
> I'm having a problem here.
>
> I have a table Pages, which belongsTo Categories. I'm using an
> "ordenable"
> behaviour, and so both pages and categories have a field called
> "index".
> Problem is, in my pages_controller, i wrote this:
>
> var $paginate = array ('order' => 'index');
>
> And as a result, I receive an error saying
>
> SQL Error: 1052: Column 'index' in order clause is ambiguous
>
> It must be because both categories and pages have the same field. I
> cant
> change this field...so how can I specify that I want to use the
> index from
> the Pages table?
>
> Thanks!!
> --
> View this message in context:
> http://www.nabble.com/Paginate---order-clause-is-ambiguous%21-tp25530985p25530985.html
> Sent from the CakePHP mailing list archive at Nabble.com.
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
