Gotcha, I didn't realized that they were prices that they were entering. It makes sense then that you are having to jump through the extra hoops.
Dean On 3/13/07, Rick Faircloth <[EMAIL PROTECTED]> wrote: > 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
