Hi, all.
This does actually involve CF 8, (and yes, I'm on CF 8 now, from 4.5 with my new VPS from ahphosting.com!) since I manipulate the value (typically, MySQL 4.1) before inserting. I've got a MySQL field of decimal for the monetary value. Previously, in MySQL 4.1, I would use decimal as the field type. Upon inserting I would use lsparsecurrency(fieldname) and insert. Worked fine MySQL 4.1. But 5.0 drops the digits after the decimal upon storage. I'm looking for the right combination of SQL and CF code to properly format, store, and retrieve the monetary value. Clues anyone? Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289811 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
