Cakephp sql decimal input form

Question

I use cakephp 2.6.4. and sql srv 2012. I need to save decimal number in format decimal(4,2) -> 4 digits before , and 2 after separator.

In sql server i have data type decimal(4,2) and in model i have validation 'rule' => array('decimal',2).

When i try to save for example 4213,12 it reports message need to round number to 4213 or 4214 I tryed with dot (.) as delimiter, but not works

When i set data type in sql srv float, then i can save, but does not work with decimal,

Any help please? Tnx

next i tryed with numeric(4,2) in sql srv, but same thing as with decimal(4,2)
my validate array is: 'coordinate_x' => array( 'numeric' => array( 'rule' => array('decimal',2),

-and everything alse is commented

i managed to get SQL error: Error: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Error converting data type varchar to numeric. i removed validate rules for that field. it seems that dacimal value in cakephp equals character. but when i roll back validation rules, than i get error to round a number for example from 1234,12 to 1234 or 1235

What is the SQL INSERT/UPDATE that is being generated by Cake? — drmonkeyninja
– drmonkeyninja, Commented Jun 2, 2015 at 8:56
i dont get any sql. by pressing submit i get red border around input field with massage. no sql is executed i think. and i think these massage is browsers massage and is connected with database data type. is it possible? — marko_b123
– marko_b123, Commented Jun 2, 2015 at 9:04
It sounds like the data is failing on validation and therefore CakePHP is not attempting to update the database. Could you update your question with your model's $validate array? — drmonkeyninja
– drmonkeyninja, Commented Jun 2, 2015 at 9:36
See github.com/dereuromark/cakephp-tools/blob/2.x/Model/Behavior/… — mark
– mark, Commented Jun 2, 2015 at 9:37

marko_b123 · Accepted Answer · 2017-01-11 12:54:57Z

3

Resolwed with HTML requirement:

<input type="number" step="0.01">

edited Jan 11, 2017 at 12:54

answered Jan 11, 2017 at 12:38

marko_b123

3102 silver badges17 bronze badges

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

Comments

Supravat M · Accepted Answer · 2015-06-02 09:49:54Z

1

$this->Number->format(); can be used to change the format of the number.

Example:

$this->Number->format(floor($session->read('max_price')), 
      array('escape' => false, 
            'places' => 0, 
             'thousands' => ','
      ));

Place attribute is used to set the decimal value .

edited Jun 2, 2015 at 9:49

Supravat M

2,5722 gold badges24 silver badges36 bronze badges

answered Jun 2, 2015 at 8:33

Karthik Keyan

4264 silver badges15 bronze badges

6 Comments

marko_b123 Over a year ago

that can i set in controllers beforeSave, i guess?

Karthik Keyan Over a year ago

No is not work in controller,Its works only view file

marko_b123 Over a year ago

but in view i have only a row for that field: echo $this->Form->input('coordinate_x', array('label' => 'Koordinata X', 'title' => 'x u htrs'));

Karthik Keyan Over a year ago

Can use with help of Java script to change the format number while u have typing in text box wait i post the link

Karthik Keyan Over a year ago

digitalbush.com/projects/masked-input-plugin use link to change format of number while u have typing in the input box

|

Collectives™ on Stack Overflow

Cakephp sql decimal input form

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related