Hello. i have 2 models linked together with a simple hasMany relationship. Customer hasMany Order // Order belongTo Customer
Customers are stored in an external DB so the Customer model uses a different DB connection now... i coded 2 views: customers/index and orders/index - customers/index. This view is displaying ONLY customer data --> i can order by customer.name without problems - orders/index. This view displays the order data (including customer's name) --> when i try to order by Customer.name i get an error like this: Warning (512): SQL Error: 1054: Unknown column 'Customer.name' in 'order clause' [CORE\cake\libs\model\datasources\dbo_source.php, line 635] and the table won't order. i guess the DB Connection is the culprit. is there any solution/workaround?
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
