Perfect! Thanks, Dave! Thanks for your help, too, Barney! When was "scale" added? Never heard of that one...
Rick -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, September 30, 2007 2:56 PM To: CF-Talk Subject: RE: Trouble storing monetary values in MySQL 5 > Here's what I'm using currently, and have used for years with > MySQL 4.1. > > debit_amount = <cfqueryparam cfsqltype="cf_sql_decimal" > value="#lsparsecurrency(form.debit_amount)#"> > > I run validation to make sure the input only contains > numbers, a dollar sign, comma, or period... common elements for money. > > Then, I use the lsparsecurrency above to make sure the value > is valid currency. > > Suggestions? I suggest you use the SCALE parameter of CFQUERYPARAM. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
