That did the trick!
Thanks!
lapinski wrote:
>
>
> 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-tp25530985p25531276.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
-~----------~----~----~----~------~----~------~--~---
