Hi mdb,
this will solve your issue w dropdown, using find('list):
http://bakery.cakephp.org/articles/view/multiple-display-field-3
On 5 Apr, 03:27, mdb <[email protected]> wrote:
> Hi,
>
> Thanks. Now I'm getting the dropdown without error. But the dropdown
> displays the ID field instead of
> categoryname.
>
> Also how do i make the selected categoryid to be stored in the events
> table when i click add button
>
> Please help
>
> On Apr 4, 1:38 am, John Andersen <[email protected]> wrote:
>
>
>
> > In your EventCategory model, you have to specify that the default
> > display name is not "name" but is "categoryname".
> > Seehttp://book.cakephp.org/view/71/Model-Attributes#displayField-438
> > for information on the models attribute "displayName"
>
> > [code]
> > var $displayName = 'categoryname';
> > [/code]
>
> > Then the find('list') will be able to use the correct table column!
>
> > Enjoy,
> > John
>
> > On Apr 4, 1:10 am, mdb <[email protected]> wrote:
>
> > > Hello
>
> > > Thanks for the reply. But i'm very new to php, so let me go one step
> > > at a time.
>
> > > HABTM in my understanding is to create cross reference tables. (If i'm
> > > not right, please correct me)
>
> > > But my case is as follows:
>
> > > Events is a master table where eventcategoryid is a foreign key
> > > column (which comes from Eventcategory master).
>
> > > First i want to make thedropdowndisplay workable properly.
>
> > >dropdownis displayed, but for each record there are 3 records in the
> > > drop down (1. label, 2. category name and 3. category id) whereas it
> > > should be just categoryname as text and id as value.
>
> > > I tried
> > > $this->set('eventcategories', $this->Event->EventCategory-
>
> > > >find('list')); (instead of find('all') which works without error.)
>
> > > but if i use 'list' it throws following error:
> > > SQL Error: 1064: You have an error in your SQL syntax; check the
> > > manual that corresponds to your MySQL server version for the right
> > > syntax to use near 'FROM `event_categories` AS `EventCategory` WHERE
> > > 1 = 1' at line 1 [CORE\cake\libs\model\datasources\dbo_source.php,
> > > line 666]
>
> > > Query: SELECT `EventCategory`.`id`, EventCategory. FROM
> > > `event_categories` AS `EventCategory` WHERE 1 = 1
>
> > > its missing eventcategory.categoryname, but i donno y its happening..
>
> > > Thanks in advance- Hide quoted text -
>
> > - Show quoted text -
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
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
To unsubscribe, reply using "remove me" as the subject.
