Multiply the number b7 100, round it off, and then divide by 100. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:22 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? Thanks for your help. Only thing is a list of about 1000 clients is merged into the Activ Mail tag, and so each record has to be formatted within the query itself because Active Mail only takes lists from the query, not from CFPARAM or CFSET. The emails go out only to clients who's accounts are past due, but again the email tag uses variables only coming directly from within a query. Also, the database is managed by another company and they may be averse to changing the field type to decimal with a scale of 2, although I'm going to try that as the first option. Is there anyway to perhaps format fields with a function directly in the queries? Regards, Pardeep. ----- Original Message ----- From: "Christopher Olive" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 03, 2002 12:59 PM Subject: RE: How do you change this number 70.0500 to 70.05? > try making the field "decimal" with a scale of 2. > > christopher olive > cto, vp of web development, vp it security > atnet solutions, inc. > 410.931.4092 > http://www.atnetsolutions.com > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 03, 2002 4:08 PM > To: CF-Talk > Subject: Re: How do you change this number 70.0500 to 70.05? > > > Anyone have any idea how to change a number thats being outputted from > a table as 70.0500 to 70.05 with only 2 decimal points. > > Is this doable thru a change in SQL 2000 or a change in the query > itself? > > I'm doing an email merge, and the tag used won't allow formatting of > anything within the body of the email, so the data has to be correctly > formatted before being inserted into the email. The above number is a dollar > amount owed by customers past due, so it need to be displayed in the > email as $70.05 and right now shows as $70.0500 > > Appreciate any insights. Thanks. > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
