Try right aligning your data and wrapping the field in a numberformat.
At 10:19 AM 12/15/00 -0600, you wrote:
>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
