How do you round it off?
> 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. > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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