?
Solved

Getting currency (i.e. $12.57) to display correctly

Posted on 2000-02-22
4
Medium Priority
?
190 Views
Last Modified: 2013-12-24
I really, really need your help.  I have been using cold fusion (learning it).  I am a web page developer and have an account that CF would work with.  I have tried and tried to get it to report my data in currency format and it just won't show up properly.  I'm really frustrated.  My manual is "Cold Fusion 4.0" by Ben Forta.
 
here is an example:
 
Toy Banks
Stock Number Description In Stock Retail Category
16022.0  660 Int. 1999 TF 1st 1/64  5.0  $15.0000  T1  

 
 
As you can see there are decimals that aren't wanted and 4 zeros after dollar amount. If you can tell me what I am doing wrong, please do so. I should also say that MS Access is my database and the cells are formatted as currency and it looks fine there.
0
Comment
Question by:soppel022200
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 5

Expert Comment

by:nathans
ID: 2549034
     #NumberFormat("",'_$____.__')#

   
0
 
LVL 5

Accepted Solution

by:
nathans earned 400 total points
ID: 2549039
#NumberFormat("",'_$____.__')#

$15.00

#NumberFormat("",'$____.__')#

$   15.00

Here are two types.

If you were getting my new ColdFusion Tips Plus e-ZINE you would not have had to ask the question.

Check it out at
http://www.nsnd.com/cftips

or subscribe to the weekly e-ZINE by
emailing a blank email to
subscribe-cftips@nsnd.com



0
 
LVL 5

Expert Comment

by:nathans
ID: 2549045
#NumberFormat("#myvar#",'$____.__')#
0
 

Author Comment

by:soppel022200
ID: 2550417
I am impressed! your answer worked. I tried this earlier and it didnt work. I think I left the quotes out.  Thanks!! SteveO
0

Featured Post

Understanding Web Applications

Without even knowing it, most of us are using web applications on a daily basis. Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We often confuse these web applications tools for websites.  So, what is the difference?

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question