Funny, things are changing depending on order of elements in $uses using var $uses = array('LocalAccount','LocalNumber'); - gives me same problem as at the beginning - first queries number of records in LocalAccounts, then just calls describe LocalNumbers, and no selects var $uses = array('LocalNumber') - the one described above - it first queries number of records in LocalNumbers, then describe LocalAccounts, and Select for each local number existing: SELECT `LocalAccount`.`id`, `LocalAccount`.`user_id`, `LocalAccount`.`local_number` FROM `local_accounts` AS `LocalAccount` WHERE `LocalAccount`.`local_number` = '10001' SELECT `LocalAccount`.`id`, `LocalAccount`.`user_id`, `LocalAccount`.`local_number` FROM `local_accounts` AS `LocalAccount` WHERE `LocalAccount`.`local_number` = '10002' SELECT `LocalAccount`.`id`, `LocalAccount`.`user_id`, `LocalAccount`.`local_number` FROM `local_accounts` AS `LocalAccount` WHERE `LocalAccount`.`local_number` = '10003' SELECT `LocalAccount`.`id`, `LocalAccount`.`user_id`, `LocalAccount`.`local_number` FROM `local_accounts` AS `LocalAccount` WHERE `LocalAccount`.`local_number` = '10004'
On 12 Gru, 11:16, Zwift <[EMAIL PROTECTED]> wrote: > Thanks. > After more investigation I found out that bake didn't add uses > LocalNumber to LocalAccounts Controller > However after I added this > It displays LocalAccounts for each existing LocalNumber... > Example > I have LocalNumbers 10001, 10002, 10003, 10004 > and only one LocalAccount with assigned number 10003 > > But it displays all of them (there is a SELECT query for each existing > LocalNumber), it looks more or less like this > id | user_id | localNumber > | | 10001 > | | 10002 > 1 | 1 | 10003 //this record exists > | | 10004 > > and this is done only when using associacion between two databases > (there is no problem in when both tables are in one because of JOIN I > guess) > can I prevent cake for doing this somehow ?? > > On 11 Gru, 14:54, grigri <[EMAIL PROTECTED]> wrote: > > > I just copied a model across from another project and added the > > dbconfig to the config file under a different key. > > > Code + SQL here :http://openpaste.org/en/4255/ > > > (I always have a 'playground' cake app setup on my local machine for > > various testing and experimentation) > > > On Dec 11, 1:38 pm, Zwift <[EMAIL PROTECTED]> wrote: > > > > Can you paste here your SQL Dumb, and models code > > > > I just don't understand whats going on here? > > > > Or did you used my above example?? > > > > Hell... > > > Darkness... > > > > On 11 Gru, 14:11, grigri <[EMAIL PROTECTED]> wrote: > > > > > I just ran a quick test (I've never actually needed to have more than > > > > one db config for the same app so far) and it works fine, even without > > > > the external bit. > > > > > It seems completely transparent, and it's only seeing the sql logs > > > > that you realise it does a separate query, not a join, for the > > > > external association. > > > > > On Dec 11, 12:35 pm, Zwift <[EMAIL PROTECTED]> wrote: > > > > > > After some researching I just need to know - is it even possible??? > > > > > Many people (on IRC) says: yes, sure > > > > > But hell I cannot make it work even with simples User <-> Profile > > > > > associacion (from tempdocs) > > > > > > On 11 Gru, 11:56, Zwift <[EMAIL PROTECTED]> wrote: > > > > > > > I think > > > > > > nothttp://api.cakephp.org/1.2/libs_2model_2model_8php-source.html(from > > > > > > line 260) > > > > > > > On 11 Gru, 11:44, grigri <[EMAIL PROTECTED]> wrote: > > > > > > > > If your models are using different datasources you have to set the > > > > > > > 'external' attribute in the association (I think). > > > > > > > > On Dec 11, 9:28 am, Zwift <[EMAIL PROTECTED]> wrote: > > > > > > > > > 2 Models > > > > > > > > FIRST: > > > > > > > > > class LocalNumber extends AppModel { > > > > > > > > var $useDbConfig = 'prepaid'; > > > > > > > > var $useTable = 'cards'; > > > > > > > > var $primaryKey = 'number'; > > > > > > > > var $displayField = 'number'; > > > > > > > > var $name = 'LocalNumber'; > > > > > > > > var $recursive = 2; > > > > > > > > > var $hasOne = array( > > > > > > > > 'LocalAccount' => array( > > > > > > > > 'ClassName' => 'LocalAccount', > > > > > > > > 'foreignKey' => 'local_number_id' > > > > > > > > ) > > > > > > > > ); > > > > > > > > > } > > > > > > > > > SECOND: > > > > > > > > class LocalAccount extends AppModel { > > > > > > > > > var $name = 'LocalAccount'; > > > > > > > > > var $belongsTo = array( > > > > > > > > 'LocalNumber' => array('className' => > > > > > > > > 'LocalNumber', > > > > > > > > 'foreignKey' => > > > > > > > > 'local_number_id') > > > > > > > > ); > > > > > > > > > } > > > > > > > > > And I have no idea why its not working - LocalNumber just > > > > > > > > doesn't > > > > > > > > appear in view (view and controller were baked). > > > > > > > > Any ideas? Maybe I did something wrong?? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---