HABTM relationship

2012-02-23 Thread jholcomb
I am having a problem with an HABTM that has a forth table involved. Here's the break down Individuals AccountsTrailers AccountsTrailersIndividuals AccountHolders AccountsTrailersIndividuals has a field account_holder_id so that I can associate an individual with an accountstrailer the error I

Re: Problems with sessions

2012-01-06 Thread jholcomb
never mind I figured out my problem. I needed to add the Session to my helpers array in my app controller. Found it after reading the manual for the forth time. -- View this message in context: http://cakephp.1045679.n5.nabble.com/Problems-with-sessions-tp5125948p5125998.html Sent from the CakeP

Problems with sessions

2012-01-06 Thread jholcomb
Hello all, I am trying to add a menu system to my project so that it appears on all my pages. The one I was able to find that looked good to me is found here, http://www.palivoda.eu/2008/04/dynamic-menu-in-cakephp/ The problem I am running into is after doing everything the site said to do I get

Re: Paginator not working on custom query

2011-12-16 Thread jholcomb
the paginate function is in my model this is what is in my controller $delinquentLoans = $this->DelinquentLoan->paginate('m-z'); $this->set('delinquentLoans', $delinquentLoans); mysql is the database server. Do I have to do something like var $helpers = array('paginator'); in

Paginator not working on custom query

2011-12-16 Thread jholcomb
I am trying to get my custom query to paginate. Reading through the book and searching has not been all that helpful to me. A few places have said to put a function paginate in the model which I have done. The 2 functions that I understand to need follow. public function paginate($conditions = nu

Re: cakephp find all with several tables

2011-12-15 Thread jholcomb
my next question has to do with how do I apply pagination to this query? -- View this message in context: http://cakephp.1045679.n5.nabble.com/cakephp-find-all-with-several-tables-tp5077723p5078473.html Sent from the CakePHP mailing list archive at Nabble.com. -- Our newest site for the communi

Re: cakephp find all with several tables

2011-12-15 Thread jholcomb
Got it here is the final version of the code for those who may want to know. [code] $this->recursive = -1; return $this->find('all', array( 'contain'=>array( 'Loan' => array( 'fields' =>

Re: cakephp find all with several tables

2011-12-15 Thread jholcomb
Tried it I think, here is my new code. [code] $this->recursive = -1; return $this->find('all', array( 'contain'=>array( 'Loan' => array( 'fields' => array('id', 'loan_description', 'acc

cakephp find all with several tables

2011-12-15 Thread jholcomb
My problem is I am trying to get data from 5 different tables all the tables are related and I can create a sql query to get what I want. Here it is. [code] SELECT accounts.account_number, trailers.id, members.first_name, balances.balance, loans.loan_description, delinquent_loans.days_delinquent,