Welcome, Guest
Username: Password: Remember me

TOPIC: Decimals

Decimals 26 Jan 2012 06:55 #1090

  • tr4ding
  • tr4ding's Avatar
  • Offline
  • Senior Member
  • Posts: 42
  • Karma: 1
By the way.....on a "latitude" field, i choose a custom validation for my float type with an handler "float_10_6" and a regular expression "^\d{0,4}(\.\d{0,6})?$".....

If i insert a "correct value", such as 38.111534, it's truncated in the last 2 digits and it appears as "38.1115".....what am i missing?

Thank you in advance for your strong support....
The administrator has disabled public write access.

Re: Decimals 26 Jan 2012 11:03 #1093

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
The problem is not about regex.
I quite sure you can submit the form without validator alert.

Look in your database :
The format sould be DECIMAL(8, 2)

DECIMAL(precision, scale)
pecision is the TOTAL number of digits.
scale is how many digits before the '.' (units)

I think this is your problem. Your regex seems fine.
Coding is now a piece of cake
The administrator has disabled public write access.

Re: Decimals 26 Jan 2012 11:07 #1095

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
Oh, excuse me I checked your project.

You are using floats.
Try to use decimal format and configure DECIMAL(8,2) in the poperties. (Precision/scale)
Coding is now a piece of cake
The administrator has disabled public write access.
The following user(s) said Thank You: tr4ding

Re: Decimals 26 Jan 2012 14:57 #1102

  • tr4ding
  • tr4ding's Avatar
  • Offline
  • Senior Member
  • Posts: 42
  • Karma: 1
Thank you!!!! Works fine!!!! I appreciate a lot!!!
Last Edit: 26 Jan 2012 16:14 by tr4ding.
The administrator has disabled public write access.
Time to create page: 0.083 seconds

Get Started