How's this when it's time to format your number, put the maximum number of
9s you think you'll be needing...
<CFOUTPUT>$ #NumberFormat(myValue, "999,999,999,999,999,999.99")</CFOUTPUT>
I don't think there's an automatic format for currency like there is for
Date but check around there might be.
Just reformat your out put command.
Julia Green
[EMAIL PROTECTED]
----- Original Message -----
From: William J Wheatley <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 11:43 PM
Subject: MONEY PROBLEM IN SQL
> I have a sql statement that is inputing 15000 into (example data) a money
> field in SQL
> When i run a query from sql advantage i see 15,0000.00
>
> when i pull up the data from CF i get
> 6.442450944E+13
>
> any ideas?
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
