Hi guys!

I have a dropdown where you can choose an opening year of a themepark 
attraction.

Database

Column: opened
Type: year(4)
Null: no
Standard value: none

So far so good. Now I try to display a dropdown with year values between 
1954 (opening park) and the current year + 1.

edit.ctp

echo $this->Form->inputs(array(
    'legend' => false,
    'name' => array(
        'label' => 'Name'
    ),
    *'opened' => array(*
*        'type' => 'year',*
*        'label' => 'Year opening',*
*        'dateFormat' => 'Y',*
*        'minYear' => 1954,*
*        'maxYear' => date('Y') + 1,*
*        'empty' => 'Kies...'*
*    ),*
    'show' => array(
        'type' => 'radio',
        'legend' => 'Show on website',
        'options' => array(
            'Y' => 'Ja',
            'N' => 'Nee'
        )
    )
));

But here comes my first problem. The dropdown output is a list with values 
from 2034 to 0 and that's not the kind of options I want. When I change the 
type to "date", the options do work great then. BUT then the selected value 
on edit is always "1970" (database says 1984). What could be the problem 
here?

My second problem occurs when saving the changes. Everytime I do so, I've 
got the error:

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 
> 'field list'


I've debugged the request object and saw the following:

object(CakeRequest) {
params => array(
'plugin' => 'coaster_cms',
'controller' => 'attractions',
'action' => 'edit',
'named' => array(),
'pass' => array(
(int) 0 => '1'
)
)
data => array(
'Attraction' => array(
'name' => 'Boomerang',
'opened' => array(
'year' => '1984'
),
'show' => 'Y'
)
)
}

As you can see, the "opened" value send to the request object is an array. 
How can I change it so the data array have something like 'opened' => 1984 
in it?

Thanks for helping me ;)

-- 
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 cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to