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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

