> 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289821 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
