No, I don't want the decimal. That way my only reason for using the mask. The presence of the decimal violates a "digits only" rule in the jQuery javascript validation I'm using on the form fields. So, I thought I'd just strip it out with the NumberFormat function...
-----Original Message----- From: Christopher Jordan [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:43 PM To: CF-Talk Subject: Re: What is wrong with this? Rick, As a test, have you tried replacing Get_Property_Details.Sale_Price with a hard-coded value? Also, have you tried changing your mask to 9999.99 (or don't you want the decimal to show)? Chris Rick Faircloth wrote: > 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 >> >> >> >> >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272435 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
