If you have the number 255900.00, how do you want to end up looking? I don't know NumberFormat very well, but I'm not sure what you're trying to get by masking it with 9999.
-- Josh ----- Original Message ----- From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, March 12, 2007 2:23 PM Subject: RE: What is wrong with this? > 255900.00 > > It's showing in the database as 255900 > but because it's a decimal data type, the .00 is being > tacked on the end. > > Rick > > -----Original Message----- > From: Josh Nathanson [mailto:[EMAIL PROTECTED] > Sent: Monday, March 12, 2007 5:10 PM > To: CF-Talk > Subject: Re: What is wrong with this? > > If you just cfoutput #Get_Property_Details.Sale_Price#, what does it say? > > -- Josh > > > ----- Original Message ----- > From: "Rick Faircloth" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Monday, March 12, 2007 2:05 PM > Subject: RE: What is wrong with this? > > >> That was the first thing I tried...didn't help. >> >> Strange... >> >> Rick >> >> -----Original Message----- >> From: Josh Nathanson [mailto:[EMAIL PROTECTED] >> Sent: Monday, March 12, 2007 4:56 PM >> To: CF-Talk >> Subject: Re: What is wrong with this? >> >> Try using single quotes around the 9999. >> >> -- Josh >> >> >> >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
