I am using rdBloggery and adding on a few custom pieces to the system
for a fun project to learn cakephp better.
I have a list of users and they are sorting by whichever header I
click on, but I ran into a problem causing me a little grief. I added
a column from my Transaction model to the User list to show their
latest transaction total. My new controller (TransactionsController)
uses the standard pagination helper included with rdBloggery.
My User model $hasMany looks like this:
var $hasMany = array(
'Post' => array(
'className' =>'Post',
'foreignKey'=>'user_id',
),
'Photo' => array(
'className' =>'Photo',
'foreignKey'=>'user_id',
),
'Comment' => array(
'className' =>'Comment',
'foreignKey'=>'user_id',
),
'Transaction' => array(
'className' =>'Transaction',
'foreignKey'=>'user_id',
'limit' =>'1',
'order'
=>'Transaction.created DESC',
),
);
and my Transaction model $belongsTo looks like this:
var $belongsTo = array(
'User' =>
array('className' => 'User',
'foreignKey' => 'user_id',
),
);
On the user list page I am trying to sort the list by a column created
from the a single transaction record, when I try this:
<th><?php echo $pagination-
>sortLink('Funds',array('Transaction.total','desc'))?></th>
I receive the following message:
Query: SELECT `User`.`id`, `User`.`username`, `User`.`password`,
`User`.`role`, `User`.`email`, `User`.`name`, `User`.`created`,
`User`.`modified` FROM `users` AS `User` WHERE 1 = 1 ORDER BY
`User`.`Transaction`.`total` ASC LIMIT 25
This returns "SQL Error: 1054: Unknown column 'User.Transaction.total'
in 'order clause'" I want it to know to use the transactions table (so
FROM 'transactions' AS 'Transaction' would also be included in the sql
query somehow?)
Is it possible to sort by a column that is in a separate table? Is
this possible?
Would I need to provide you guys with any more information before this
question could be answered?
Thanks in advance.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
