thanks! dave ----- Original Message ----- From: "Dave Carabetta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 9:24 PM Subject: Re: currency tag?
> > I seem to remember cf having a nice lil function to format a form entry to > convert it to dollars. was it dollarFormat? > > basically, I need to make sure entries get inserted into the access db in > the correct manner ($4,345.00) > > I have tried to set the db to currency but when I do the insert quits > working > > As a matter of good practice, I wouldn't use DollarFormat() because you will > be storing the dollar sign as well. Try using the NumberFormat() function, > making sure to provide a format mask that matches the largest possible value > you would expect from that field. As an example: > > Update myTable > SET cost = #Trim(NumberFormat(form.myField, "999,999.99"))# > WHERE id = 1 > > The Trim() function will remove any leading padding if the number passed in > isn't as big as the mask provided. > > Regards, > Dave. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
