I'm using cfgrid cfgridcolumn to display data on a page. Somehow the following code does not show the comma. Cfgrid is in html format.
<cfgridcolumn name="InletFlueGasFlow_acfm" numberformat="9,999,999" header="Inlet Flue Gas Flow ACFM">
tried also with type
<cfgridcolumn name="InletFlueGasFlow_acfm" type="numeric" numberformat="9,999,999" header="Inlet Flue Gas Flow ACFM">
What is a valid numberformat? The Adobe documentation for cfgridcolumn says numberformat="format"
9 Optional digit placeholder. Same as _ but shows decimal places more clearly.
, Separates thousands with commas.
Any idea why my comma not showing?
Is the data coming from a query? Is the query field numeric or a string of some kind? For example, although its number it could be stored in a varchar datatype which cfgrid might not see as numeric and not apply the format to.
The field is coming from a query. It is defined as int in the table.
I used an alternate solution to solve my problem by formatting the numbers in sql query.