Data Types

[mcfloydParticipant]

Hello,
If you specify a data type for a certain field (say, currency) and the field is a stringified float, will jqxGrid automatically convert this field? If not, how can I cast with the data binding function ($.jqx.dataAdapter) if I already know the types from the column sets?

For some reason ZF2 only returns strings from the database and there isn’t a workaround that I know of…

Thanks

[Peter StoevKeymaster]

Hi mcfloyd,

The valid data types are: ‘number’,’ bool’, ‘date’, ‘int’, ‘float’ and ‘string’. If you want to format a number as currency, you will have to set the column’s cellsformat property to “c2”, “c”, “c3” or something like that depending on how many decimal characters you would like to have.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[mcfloydParticipant]

If I use the formatter, will it convert a string to another type? Or does it have to be cast as the column field’s set type before it is bound?

[Peter StoevKeymaster]

Hi mcfloyd,

You have to set the type property of your data fields when you create the jqxDataAdapter.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[mcfloydParticipant]

OK thank you.

[Author]

Posts