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.
