> Ah...Well that would be a problem. You need at least a scale of 2. It looks like there may be > an issue with the way numeric is being deployed in Fourq. Let me take a look at the code > and I'll get back to ya.
Did anyone ever come up with an answer on how to store currency values as an object property? We also need to be able to store currency values for an object (using MySQL, btw). I've tried all the obvious property options; "currency", "money", "decimal(11,2)", etc, but no dice. In MySQL, numeric creates a column of type int(11). Would it screw things up royally if I used "numeric" in the property tag, deployed it and then manually adjusted the precision and scale using SQLyog? Thanks -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> Fairbanks uses anti-spam filtering. If you sent an e-mail and expected to receive a response but didn't, please call -- it may be that your e-mail didn't make it to the intended mailbox. ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
