On Monday, March 12, 2012 5:32:14 PM UTC+5:30, Graham wrote:
>
> Dear All. I would like some advice please. I am new to CakePHP and so far
> I am loving it. I am keen to do things the “right way” so I am interested
> in any comments.
>
>
>
> What I describe in the following I have working. I am interested in
> knowing if I have gone about it the right or wrong way.
>
>
>
> I have a table with a varchar field that I want to complete with data from
> another table – my choices table. There is no connection between the two
> tables.
>
>
>
> In my controller I have the following:
>
>
>
> App::import('Model', 'Choice');
>
> $tmpChoice = new Choice();
>
>
>
> $titles = $tmpChoice->find('list', array(
>
> 'fields' => array('item', 'item'),
>
> 'conditions' => array('cat' => 'title'),
>
> 'recursive' => 0
>
> ));
>
> $this->set(compact('titles'));
>
>
>
> I have this in my view:
>
>
>
> echo $this->Form->input('title',
> array('type'=>'select','options'=>$titles));
>
>
>
> Above, I needed to instantiate the Choice model class to make it available
> to my code. When I used:
>
>
>
> $titles = $this->MainTable->Choice->find('list',…
>
>
>
> I received an error saying that I was trying to execute a function of an
> object that isn’t a class. I resorted to my above code to resolve the error.
>
>
>
> The “fields” array specifies “('item', 'item')”. This I did so that I
> could have the value and the option the same – I didn’t want to insert the
> id key into the database, I wanted the text. The “conditions” statement is
> present so that I can select the appropriate category of choices.
>
>
>
> Thanks for looking at this and making any comments about the code.
>
>
>
> With regards
>
>
>
> Graham Jones
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
