Thank you so much. I think I am 99% there.
Get the following error three times, (that is actually how many contacts
are in the DB for the customer I was looking up.
debug($results);
*Notice* (8) <javascript:void(0);>: Undefined index: Contacts [*
CORE\Cake\Model\Datasource\DboSource.php*, line *1412*]
Code <javascript:void(0);> Context <javascript:void(0);>
} } else {
$this->_mergeAssociation($row, $fetch, $association, $type,
$selfJoin);
$data = array(
'TblAccount' => array(
),
'Address' => array(
),
'Contacts' => array(
)
)
$merge = array(
(int) 0 => array(
),
(int) 1 => array(
),
(int) 2 => array(
)
)
$association = 'Contacts'
$type = 'hasMany'
$selfJoin = false
$i = (int) 1
$row = array(
(int) 0 => array(
)
)
$insert = array()
DboSource::_mergeAssociation() -
CORE\Cake\Model\Datasource\DboSource.php, line 1412
DboSource::queryAssociation() -
CORE\Cake\Model\Datasource\DboSource.php, line 1274
DboSource::read() - CORE\Cake\Model\Datasource\DboSource.php, line 1087
Sqlserver::read() - CORE\Cake\Model\Datasource\Database\Sqlserver.php, line 600
Model::find() - CORE\Cake\Model\Model.php, line 2698
TblAccountsController::view() -
APP\Controller\TblAccountsController.php, line 28
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE\Cake\Controller\Controller.php, line 485
Dispatcher::_invoke() - CORE\Cake\Routing\Dispatcher.php, line 103
Dispatcher::dispatch() - CORE\Cake\Routing\Dispatcher.php, line 85
[main] - APP\webroot\index.php, line 92
Co
I copied the SQL Dumb into MS SQL query and it gave me the records I needed.
Thanks!
On Thu, May 24, 2012 at 9:38 AM, Mike Griffin <[email protected]> wrote:
> On Thu, May 24, 2012 at 3:14 PM, hill180 <[email protected]> wrote:
> > Yes.
> >
> > As a disclaimer, I didn't write the original schema.
> >
> > Account_ID is for the systems account number (primary key)
> > Account is for the logical account number (used by the company)
> >
> > The Account Address table use the Account_ID as the foreign key, but the
> > Contact Table uses the Account Number as the foreign key.
> >
> > SQLDUMP:
> >
> > SELECT [CONTACT_FULL_NAME] AS [Contact__CONTACT_FULL_NAME],
> > [Contact].[CONTACT_FIRST_NAME] AS [Contact__CONTACT_FIRST_NAME] FROM
> > [CONTACTS] AS [Contact] WHERE [Contact].[Account_ID] =
> [Accounts].[Account]
> >
> >
> > error:
> >
> > Error: SQLSTATE[42000]: [Microsoft][SQL Server Native Client
> > 11.0][SQL Server]The multi-part identifier "Accounts.Account" could not
> be
> > bound.
> >
>
> Right so.
>
> You can do it this way instead. Remove the conditions array from the
> model association and put this in:
> 'finderQuery' => 'SELECT Contact.name FROM contacts AS Contact LEFT
> JOIN accounts AS Account ON Contact.account_id=Account.account WHERE
> Account.AccountID = {$__cakeID__$}'
>
> You can edit the SELECT query to return whatever values you want but
> leave in the {$__cakeID__$} bit as it is the value of the primary key.
>
> I hope this makes sense.
>
> Mike.
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> [email protected] For more options, visit this group
> at http://groups.google.com/group/cake-php
>
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
