Zend framework - db_table - wrong datatype being saved

Question

I'm using the Zend_db_table insert() method and get an error. The error is because I receiving data from POST as a string but the datatype for the table column is float. So it creates error when I try to insert string type into float column.

What's the proper way to resolve this?

Here's the model code:

class User_Model_Forms extends Zend_Db_Table_Abstract {
    public function save(array $data) {
        return $this->insert($data);
    }
    ...

Here's the controller code:

$form = new User_Form_Firstpart();
if ( $form->isValid($request->getPost()) ){
    $data = $form->getValues();
    $formModel = new User_Model_Forms();
    $formModel->save($data);

    ...

Here's the database table:

form table

Could you paste some example code?

dinopmi
– dinopmi

2011-08-27 12:11:15 +00:00
Commented Aug 27, 2011 at 12:11 — dinopmi
– dinopmi, Commented Aug 27, 2011 at 12:11

Arnaud Le Blanc · Accepted Answer · 2011-08-27 12:26:15Z

1

Try converting the input to float before passing it to insert:

$this->insert(array(
    'someColumn' => (float) $the_value,
));

BTW don't forget to add a float validator to your form.

answered Aug 27, 2011 at 12:26

Arnaud Le Blanc

100k24 gold badges211 silver badges196 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Zend framework - db_table - wrong datatype being saved

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related