Numeric values

[plaustrum]

Hi

I have a form which updates a ms access database with product descriptions and
values associated with the record. In this case the values are a decimal number
10.99 for example.

The ms access database field is set up as a fixed integer with 2 deciimal
places

The cf form submits the data as text but seems to strip off the decimal place
digits, so uploading 10.99 puts just 10.00 into the data field.

The action to insert the code is simply <cfinsert ....etc>

Any ideas - or am I missing the obvious?

Thanks

[BKBK]

To avoid confusion I would make the database column decimal type
and, in the insert statement, not use single-quotes around that data.

[plaustrum]

Many Thanks

It was the database column that needed changing from integer to decimal.

Works fine now..