Currency Format

if you inlcude the last two parameters it gives you an error.

No surprise. I didn't realize you are on MX7. I am on CF8.

Sorry about that. On MX7 you should leave out the last parameter, that is, the locale.

I don't think mask, numberformat, etc. would work. You might want to do something like:

<cfscript>
paymentQuery = queryNew("fname,lname,amount", "varchar,varchar,double");
queryAddRow(paymentQuery);
querySetCell(paymentQuery, "fname", "John");
querySetCell(paymentQuery, "lname", "Smith");
querySetCell(paymentQuery, "amount", "103.846");
queryAddRow(paymentQuery);
querySetCell(paymentQuery, "fname", "Mary");
querySetCell(paymentQuery, "lname", "James");
querySetCell(paymentQuery, "amount", "200");
queryAddRow(paymentQuery);
querySetCell(paymentQuery, "fname", "Peter");
querySetCell(paymentQuery, "lname", "Stone");
querySetCell(paymentQuery, "amount", "3.25");
</cfscript>
<cfform action = "#CGI.SCRIPT_NAME#" format="Flash">
<cfgrid name = "paymentGrid">
<cfgridcolumn name = "fname" header = "First name">
<cfgridcolumn name = "lname" header = "Last name">
<cfgridcolumn name = "amount" header = "amount" dataalign="right">
<cfloop query="paymentQuery">
<cfgridrow data ="#paymentQuery.fname#, #paymentQuery.lname#, #lscurrencyformat(paymentQuery.amount,'local','English (US)')#">
</cfloop>
</cfgrid>
<br>
<cfinput type="submit" name="gridEntered">
</cfform>

I know it is some kind of buggy but have you tried to use "mask" attribute for "cfgridcolumn" to format the currency?