I've been trying to resolve a problem with sorting on a grid column. The
grid references as Access DB. The column contains "values", which I'd like
to be nondecimal currency. The problem is that when I click on the column
and hit the "descending" sort button, the values display like this:
9972
994746
82
8111
and so on. It seems as though it is sorting this col's values as text
strings, but Access shows them as type 'number' with format=Currency. I've
tried setting the field to type=Currency in Access, but the results are the
same.
My CF code for this gridcol is:
<CFGRIDCOLUMN NAME="ytdSpend" HEADER="YTD Spend"
WIDTH="80" NUMBERFORMAT="S__,___,___"
HEADERALIGN="LEFT" DATAALIGN="LEFT"
BOLD="No" ITALIC="No"
SELECT="Yes" DISPLAY="Yes"
HEADERBOLD="No" HEADERITALIC="No">
Being new to CF within the last two weeks, I'd appreciate any suggestions.
Is there another way to set this as currency in CF (other than the
NUMBERFORMAT setting in the CFGRIDCOL tag)?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
