String reformatting issue.

[lightonbParticipant]

Hello.
I am pulling in a sql query json with one of the fields:
{name: ‘key_cut_description’, type: ‘string’},

Then I am displaying below:
{text: ‘Key Cut Description’, filtertype: ‘input’, datafield: ‘key_cut_description’, width: 300},

The database value for this description is ’80E-13′, but it is displaying in the jqxgrid as ‘8e-12’
This is one example.

Any ideas what is going on, is this trying to convert something? It is driving me bonkers.
Thanks,
Bryan

[MartinParticipant]

Hello lightonb,

Is the field type ‘string’ both in the database and in the source’s datafield type?
If so, can you send your code with some of the data, so we can take a look?
Thank you!

Best Regards,
Martin

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts