Hello,
I hope that someone can help me with this very odd problem. I'm
trying to call a custom model function, and I keep getting the
following error:
SQL Error: 1064: You have an error in your SQL syntax;
Query: getSystemUsePercent
Now, I'm using custom model functions in many other places in my
application, but this one is different in that the model is for a
hasAndBelongsToMany relationship (model is
TradingAccountsTradingSystem).
The relationships in TradingAccountsTradingSystem model are
var $belongsTo = array(
'TradingAccount' => array('className' =>
'TradingAccount',
'foreignKey' =>
'trading_account_id',
'conditions' => '',
'fields' => '',
'order' => ''
),
'TradingSystem' => array('className' =>
'TradingSystem',
'foreignKey' =>
'trading_system_id',
'conditions' => '',
'fields' => '',
'order' => ''
)
);
The function 'getSystemUsePercent' IS declared in the
TradingAccountsTradingSystem model.
I'm calling the function from a component as follows:
$this->controller->TradingAccountsTradingSystem->getSystemUsePercent
();
I've verified that the controller I'm calling the component from
'uses' TradingAccountsTradingSystem. In this case it's the
TradingAccountsController.
In the past when I've gotten this SQL error, the problem has made
sense - usually I've missed adding the appropriate controller to the
'uses' array. But this one doesn't make sense. I'm not sure what else
I need to do. Am I not supposed to be able to make these kinds of
calls to the hasAndBelongsToMany join model?
Thanks for any help.
Rob Page
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
