Try this:
var $paginate = array ('order' => 'Page.index');
Lapinski
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-tp25530985p25530991.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 [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
-~----------~----~----~----~------~----~------~--~---
