Float data types

- ☆ A M B ☆
- 24,524 Posts
sottwell Reply #1, 14 years, 9 months ago
How to specify the digits of a float in an xpdo schema? I want 5 digits, three to the left and two to the right of the decimal point.
```
 <field key="value" dbtype="float" phptype="float" null="false" default="0"/>
```
In a regular PHP table I'd use "float(5,2)"
Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org
- 24,544 Posts
BobRay Reply #2, 14 years, 9 months ago
I think this is it:
```
dbtype="decimal" precision="4,2" phptype="float"
```
Did I help you? Buy me a beer
Get my Book: MODX:The Official Guide
MODX info for everyone: http://bobsguides.com/modx.html
My MODX Extras
Bob's Guides is now hosted at A2 MODX Hosting