Hi, Dean... Well, off the top of my head.. I figure the Real Estate agents would want to be able to enter dollars and cents. (Even though there's never anything but zeros after the decimals.) It just looks more consistent with what you see as prices on Real Estate sites.
I guess the idea is to keep things the most flexible possible for the agents and give them less to complain about with entry. I just do more work on my end, but in the long run it's easier on me. Rick -----Original Message----- From: Dean Lawrence [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 13, 2007 1:05 PM To: CF-Talk Subject: Re: What is wrong with this? Rick, If the number has to be an integer, why is it being stored in the database as a decimal? Wouldn't just changing the fieldtype be the most logical thing to do instead of having to build code to compensate for it? Just at thought. Dean -- __________________________________________ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272555 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
