Ok the situation is bit complicated (to me atleast :P)
I will try my best to explain .
1. I am using cake 1.2
2. Windows env, apache, mysql, php 5
Now I am making a personal financing app, where i have users,
transactions, tables. I am storing all transaction with user_id and I
have hasMany relation between user & transaction.
I have created a view
==> "select `transactions`.`user_id` AS
`user_id`,sum(`transactions`.`amount`) AS `total` from `transactions`
group by `transactions`.`user_id`"
which returns
view name = balances
uers_id total
------------------------
1 1200
2 900
the user has "hasOne" relation with balances.
when I use
$this->set('user', $this->User->read(null, $id));
in user_controllers.php I am getting
[Balance] => Array
(
[total] => 2939.20
)
in the view ... no issues with this. But I am also getting
[transactions] =>
now this is causing problem.
the whole array is something like this
Array
(
[User] => Array
(
[id] => 1
[created] => 2007-04-07 10:21:23
[modified] => 2007-04-09 12:50:26
[username] => suman
[password] => 5f4dcc3b5aa765d61d8327deb882cf99
[name] => Suman Paul
[group_id] => 1
[active] => 1
)
[transactions] =>
[Balance] => Array
(
[total] => 2939.20
)
.........
At top I am getting an error ...
Notice (8): Undefined index: transactions [CORE\cake\libs\model
\datasources\dbo_source.php, line 685]
I understand that the error is due to blank [transactions] => and
thats becuse of the view I created.
but I was wondering why it is coming.
any body could shed any light, that will be really helpful.
reagrds
suman
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
