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 [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
-~----------~----~----~----~------~----~------~--~---
