Just tried this code, but alas, no dice:(
Thanks for the suggestion tho.
----- Original Message -----
From: "VAN VLIET, SCOTT E (SBCSI)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 2:07 PM
Subject: RE: How do you change this number 70.0500 to 70.05?
> SELECT ('$' + CONVERT(VARCHAR,DollarField)) As DollarField
> FROM TABLENAME
>
> (Where DollarField is the Column you are getting the dollar value from)
>
> The convert function trimmed off to only 2 decimals in the conversion. I
> was starting to get all crazy with SUBSTING, but I think will work just
> fine. HTH!
>
> --
> Scott Van Vliet
> Senior Analyst
> SBC Services, Inc.
> ITO Enterprise Tools
> Office: 858.886.3878
> Pager: 858.536.0070
> Email: [EMAIL PROTECTED]
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 1: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.
> >
> >
> >
>
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
