And you probably don't want a double but a Decimal in the database
either if you want some reliable behaviour. Or you could just go with
a Double in Java.
cug
On 03.07.2008, at 07:28, Ken Anderson wrote:
Gino,
What you have doesn't make sense. Precision is the total number of
digits, and scale is the total number to the right of the decimal
point.
My guess is you really want a precision of 30 and a scale of 6, not
the other way around.
Ken
On Jul 2, 2008, at 12:27 PM, Gino Pacitti wrote:
Hi all
I have a model set up which has a value for a premium.
In EOModeller I have the Internal Type set to Decimal Number with a
Precision of 6 and external Scale of 30
The external type is a Double in Mysql
ANNUALPREMIUM` double(31,30) default NULL
When the premium is calculated I can see the value - something
like: 141.755640000
but in the database it is defaulting to 10
Any idea why this could be happening?
WO 5.3.*
10.4.11
Mysql 4.11.*
mysql-connector-java-5.0.6-bin.jar
Gino
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kenlists%40anderhome.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/lists%40event-s.net
This email sent to [EMAIL PROTECTED]
--
http://www.event-s.net
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
