Skip to main content
T
tibay
Participant
March 13, 2015
Question

Cffridcolumn numberformat comma issue

  • March 13, 2015
  • 2 replies
  • 648 views

Hi,

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?

Thanks.

This topic has been closed for replies.

2 replies

T
tibayAuthor
Participant
March 17, 2015

I used an alternate solution to solve my problem by formatting the numbers in sql query.

H
haxtbh
Inspiring
March 14, 2015

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.

T
tibayAuthor
Participant
March 15, 2015

The field is coming from a query.  It is defined as int in the table.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices