On 2/14/06, Roberto Perez <[EMAIL PROTECTED]> wrote: (snip)
> Ok, but the error described in 2) pertains to an input field in a > form that contains a comma (e.g., "2,450.00") which is sent to a > database. How could numberFormat() be used (if applicable) to format > the number so that, when sent to the database, an error due to the > comma is not generated? remove any non-numeric characters (except for a decimal point) when inserting the value into the database: rereplace(myNum, '[^0-9/.]', '', 'all') -- Charlie Griefer ================================================ "...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232299 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
