This is a community question ??!!!! :-)
> ----------
> From: gcusa jingle[SMTP:[EMAIL PROTECTED]]
> Sent: 27 July 2000 13:10
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Comma Problem
>
> Simply add a replace() to your statement,
>
> replace(passedvariable, ',', 'all')
>
> This will remove ALL commas from the numeric value.
>
>
>
>
> ---------- Original Message ----------------------------------
> From: "Jim Watkins" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Wed, 26 Jul 2000 19:55:19 -0700
>
> >Below is part of a form I use to simply multiply a quantity times unit
> cost.
> The problem is that when the customer keys in a comma as in 4,000 instead
> of
> 4000 a multiplication error occurs. I get an answer but it is way wrong.
> What can I do to strip the comma out???
>
>
> <tr>
> <CFIF Len(Trim(form.qty1)) AND Len(Trim(form.unitcost1))>
> <cfset form.totalcost = #form.qty# * #form.unitcost#>
> <td><input name="unitcost" value="#form.unitcost#"></td>
> </tr>
> </CFIF>
>
> --------------------------------------------------------------------------
> ----
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_communi
> ty or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
> --------------------------------------------------------------------------
> ----
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_communi
> ty or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
**********************************************************************
This email and any attachments are confidential and solely
for the use of the intended recipient. They may contain
material protected by legal professional or other privilege.
If you are not the intended recipient or the person responsible
for delivering to the intended recipient, you are not authorised
to and must not disclose, copy, distribute or retain this email
or its attachments. Although this email and its attachments
are believed to be free of any virus or other defect, it is the
responsibility of the recipient to ensure that they are virus free
and no responsibility is accepted by the company for any
loss or damage arising from receipt or use thereof.
**********************************************************************
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
