Decimal Problem

[Guest_imported]

I'm getting data from a query. When I display it on the screen with:

<cfoutput query=&quot;thequery&quot;>
#thequery.number#
</cfoutput>

It shows the number correct with 2 decimal places. However, right after that I'm inserting that number into a table using:

INSERT INTO ThisTable(ThisField)

VALUES (#thequery.number#)

It is not keeping the decimal places. It appears to be dropping them.. I've tried to us #DecimalFormat(thequery.number)# but that does not work either. Any suggestions?

 

[Silvano]

check the data base, the data type field and if the field you are inserting the value into has some restrictions (like integers only) Sylvano
dsylvano@hotmail.com