762
Chapter 3: ColdFusion Functions
An underscore determines whether the code is placed in the far or near position. Most code
characters’ effect is determined by the field in which they are located. This example shows how to
specify where to put parentheses to display negative numbers:
To set the default display format of date, time, number, and currency values, use the
SetLocale
function.
When converting from string to double, to prevent rounding errors, this function adds a
rounding factor of 1.5543122344752E-014 to the converted number. For example, without
adding the rounding factor, converting the string value 1.275 to double with two digits of
precision results in a value of 1.27499999999999999, which would be rounded up to 1.27. By
adding the rounding factor, the conversion correctly results in a value of 1.28.
If you round off a double, such as 1.99499999999999999999999999999, where the last decimal
is 10E-14, the rounding factor can cause an incorrect result.
Example
<h3>LSNumberFormat Example</h3>
<p>LSNumberFormat returns a number value using the locale convention.
<!--- loop through a list of locales and show number values --->
<cfloop LIST = "#Server.Coldfusion.SupportedLocales#"
index = "locale" delimiters = ",">
<cfset oldlocale = SetLocale(locale)>
<cfoutput><p><b><i>#locale#</i></b><br>
#
LSNumberFormat(-1234.5678, "_________")
#<br>
#
LSNumberFormat(-1234.5678, "_________.___")
#<br>
#
LSNumberFormat(1234.5678, "_________")
#<br>
#
LSNumberFormat(1234.5678, "_________.___")
#<br>
#
LSNumberFormat(1234.5678, "$_(_________.___)")
#<br>
#
LSNumberFormat(-1234.5678, "$_(_________.___)")
#<br>
#
LSNumberFormat(1234.5678, "+_________.___")
#<br>
#
LSNumberFormat(1234.5678, "-_________.___")
#<br>
</cfoutput>
</cfloop>
Number
Mask
Result
3.21
C(__^__)
"( 3.21 )"
3.21
C__(^__)
" (3.21 )"
3.21
C(__^)__
"( 3.21) "
3.21
C__(^)__
" (3.21) "
Summary of Contents for COLFUSION MX 7 - INSTALLING AND USING COLDFUSION MX
Page 1: ...COLDFUSION MX7 CFML Reference...
Page 20: ...20 Chapter 1 Reserved Words and Variables...
Page 50: ...50 Chapter 2 ColdFusion Tags cfelse br Searching cfif cfloop cfif...
Page 101: ...cfdefaultcase 101 cfdefaultcase cfswitch cfoutput Your grade is grade cfoutput...
Page 115: ...cfdocumentsection 115 cfdocumentsection cfoutput cfdocument...
Page 411: ...cftable 411 cftable body html...
Page 515: ...Chr 515 maxlength 5 p input type Submit name input type RESET cfform...
Page 605: ...GetEncoding 605 WriteOutput The encoding is theEncoding cfscript cfif...
Page 629: ...GetProfileString 629 tr td input type Submit name Submit value Submit td td td tr table form...
Page 655: ...IIf 655 cfoutput IIf Hour Now GTE 12 DE It is afternoon or evening DE It is morning cfoutput b...
Page 664: ...664 Chapter 3 ColdFusion Functions cfelse h3 Conversion error h3 cfif...
Page 687: ...IsStruct 687 cfoutput cfquery cfif cfoutput hr Employee Add Complete cfoutput cfcase cfswitch...
Page 751: ...LSDateFormat 751 hr noshade cfoutput cfloop...
Page 861: ...StructFind 861 cfquery cfif cfoutput hr Employee Add Complete cfoutput cfcase cfswitch...
Page 903: ...Val 903 value Is the beginning numeric name form...
Page 932: ...932 Chapter 3 ColdFusion Functions...
Page 944: ...944 Chapter 4 ColdFusion MX Flash Form Style Reference...
Page 962: ...962 Chapter 5 Application CFC Reference...
Page 1054: ...1054 Chapter 6 ColdFusion MX Event Gateway Reference...