You can cast the value to an acceptable floating number with
LSParseCurrency():
update table
set field = #lsParseCurrency(form.rate)#
> -----Original Message-----
> From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 18, 2000 3:18 PM
> To: Cf-Talk@Houseoffusion. Com
> Subject: Pesky dollar format
>
>
> Hi, All
>
> I am working with MS Access DB that has a currency datatype field. I
> retrieve the data into the form:
> <cfinput type="Text"
> name="Rate"
> value=#NumberFormat(Rate, "$999999.99")#>
>
> It displays fine with the "$" where it is supposed to be, but
> when I submit
> the form (without editing), I get the SQL error complaining that
> I am trying
> to update a numerci column with a value '$300'. Somehow it is not a number
> anymore.
>
>
> Is there a way to convert the $300 back into whatever MS Access will take
> for currency field?
>
> Cyrill
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
