Re: CakePHP 2.3.8 and MySQL's YEAR Type

Will was referring to the data type, not the input type.  Cake handles all kinds of data types that are not also input types (decimal, float, etc.).  The benefit of Cake is that it has some smarts about creating inputs based on the data types in your model, but with the YEAR data type, which I admit is a little obscure, bake does indeed translate it into a TEXT data type, which the view then renders correctly as an input type=textarea.  The problem is in the model: I haven't dug into the bake code to see how it handles data types, but I suspect any data type it doesn't have a translation for it just goes to the biggest most gigantic catchall datatype that makes sense, which is TEXT.

I had the same problem in an insurance form that needed just a year in a field.  The year type in MySQL seemed to make sense, but then after the behavior that Will and I experienced, I decided to use INT(4), and set ranges.  

BTW, another limit to the YEAR data type: to keep the type small (1 byte), it's limited to a range of 255 years, which MySQL decided should start at 1901 and end in 2155 - you have no say in the range, you lowly designer of your own database.

On Sunday, August 25, 2013 10:32:48 AM UTC-7, Vanja Dizdarević wrote:

You should resolve that by using a proper form element in your views. Year is not a recognized input type

    <?php

        $options = array();

        $from = 1990;

        $to = 2030;

        for ($i = $from; $i <= $to; $i++) {

          $options[(string)$i] = (string)$i;

        }

    ?>

    <?php echo $this->Form->input('year', array( 'type' => 'select', 'options' => $options)); ?>

--
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+unsubscribe@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/d/optout.