Database design . Beginner having trouble.

2008-12-13 Thread Tanay
I have two database tables. Tenants and expenses. Tenant has many expenses. Expense belongs to tenant. When ever a new expense is created a tenant who has paid for the expense is associated with it. Now i want another relationship which is "affects". Each expense may not affect all tenants. So wh

How and where to insert a tracking script. ?

2008-12-10 Thread Tanay
I want to insert a small counter and a login code so that they are run on all cake pages. I am using default theme and css. Tell me the default template file so that i can insert these codes. --~--~-~--~~~---~--~~ You received this message because you are subscribe

Re: $this->find not interpreting "LIKE"

2008-12-10 Thread Tanay
thanks, i will try it On Dec 10, 12:58 pm, AD7six <[EMAIL PROTECTED]> wrote: > On Dec 10, 4:13 am, Tanay <[EMAIL PROTECTED]> wrote: > > > > > $expenses=$this->Expense->find('all',array( > >

$this->find not interpreting "LIKE"

2008-12-09 Thread Tanay
$expenses=$this->Expense->find('all',array( 'conditions'=> array( 'Expense.Name'=>'LIKE S%' ))); the query generated from sql dump: SELECT `Expense`.`id`, `Expense`.`name`, `Expense`.`description`, `Expense`.`amount`, `Expense`

sending parameters to a controller function

2008-12-08 Thread Tanay
i have a class type "expenses" the index() function of controller lists all expenses' then i have a function show(month,year) which lists all expenses of that particular month,year in expenses home page i want to have a form with two select buttons such that i select month and year with values,

Re: ORM, fetching related rows of corresponding model: undefined index..

2008-12-08 Thread Tanay
'models/question.php' and 'models/ > answers.php' to 'models/answer.php'. Everthing else looks ok. > > hth > grigri > > On Dec 8, 11:11 am, Tanay <[EMAIL PROTECTED]> wrote: > > > no sight of 'answers' still > > > On Dec 8

Re: ORM, fetching related rows of corresponding model: undefined index..

2008-12-08 Thread Tanay
no sight of 'answers' still On Dec 8, 4:10 pm, Tanay <[EMAIL PROTECTED]> wrote: > i changed the value to 2, > still the var_ dump is like this: > > array(2) { [0]=> array(1) { ["Question"]=> array(5) { ["id"]=> string > (1) "1&q

Re: ORM, fetching related rows of corresponding model: undefined index..

2008-12-08 Thread Tanay
5) "Why won't you use CakePHP" ["questioner"]=> string(5) "Ahsan" ["created"]=> string(19) "2008-02-11 22:22:06" ["modified"]=> string(19) "2008-02-11 22:22:06" } } } On Dec 8, 8:35 am, thatsgreat2345 &l

Re: ORM, fetching related rows of corresponding model: undefined index..

2008-12-07 Thread Tanay
m, Rob <[EMAIL PROTECTED]> wrote: > Well based on your post, you are not getting the related model, and it > appears you've only done a find on the Questions without setting > recursive in your find('all'), try this: > >  $this->set('ques

Re: ORM, fetching related rows of corresponding model: undefined index..

2008-12-07 Thread Tanay
On Dec 7, 11:00 am, thatsgreat2345 <[EMAIL PROTECTED]> wrote: > Post your model code so we can see if you are doing your associations > correctly, or if they are spelled correctly. > > On Dec 6, 9:50 pm, Tanay <[EMAIL PROTECTED]> wrote: > > > > > it seems

Re: ORM, fetching related rows of corresponding model: undefined index..

2008-12-06 Thread Tanay
ied` FROM `questions` AS `Question` WHERE 1 = 1 On Dec 7, 1:47 am, thatsgreat2345 <[EMAIL PROTECTED]> wrote: > I see you are using the Packt Publishing book, ensure that your model > relations aren't misspelled or anything else it won't load the answers > and thus wo

Re: ORM, fetching related rows of corresponding model: undefined index..

2008-12-06 Thread Tanay
Tanay wrote: > i have two dbs questions , and answers.. > > corresponding models > > questions has many answers > answers belogns to questions > > in questions_controller, i have this home function > function home() { > $this->Question->r

ORM, fetching related rows of corresponding model: undefined index..

2008-12-03 Thread Tanay
i have two dbs questions , and answers.. corresponding models questions has many answers answers belogns to questions in questions_controller, i have this home function function home() { $this->Question->recursive = 1; $this->set('questions', $this->Question->find('all'));

Newbie facing an error

2008-11-27 Thread Tanay
Warning: file_put_contents(/f1/content/cakeme/public/myapp/app/tmp/ cache/models/default_cake_list) [function.file-put-contents]: failed to open stream: Permission denied in /f1/content/cakeme/public/myapp/ cake/basics.php on line 936 Warning: file_put_contents(/f1/content/cakeme/public/myapp/app