When you set up an Access field as currency it is really a float (not a text
field). The currency designation simply sets the way that the data are
displayed to the user (with a dollar sign and two decimal digits). So, when
you insert into the database make sure that you are entering the data as a
float like:
insert into blah (mycurrency) values (100.00)
HTH,
Howie Hamlin
--
inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668
www.CoolFusion.com
============================================================
Please vote for iMS in the Most Innovative category here:
*** http://www.sys-con.com/ColdFusion/readerschoice2000/ ***
============================================================
Check out inFusion Mail Server - the world's most configurable email server
----- Original Message -----
From: Cyrill Vatomsky <[EMAIL PROTECTED]>
To: Cf-Talk@Houseoffusion. Com <[EMAIL PROTECTED]>
Sent: Thursday, May 18, 2000 6:18 PM
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.
