Try size="7,2" instead of size=".." scale=".."
> -----Ursprüngliche Nachricht----- > Von: Jon August [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 14. Dezember 2006 13:52 > An: Apache Torque Users List > Betreff: Re: BigDecimal and MySQL decimal > > > Hey Alvaro, > > Thanks for the suggestion. I tried this: > > <column name="price" scale="2" size="7" > type="DECIMAL" /> > > but I get this error when I run "maven torque": > > org.apache.torque.engine.EngineException: org.xml.sax.SAXException: > Error while parsing wp-schema.xml at line 13 column 77 : Attribute > "scale" must be declared for element type "column". > > > Is my syntax incorrect? > > -Jon > > > > > > On Dec 14, 2006, at 7:24 AM, Alvaro Coronel wrote: > > > I have had no trouble using it just as you do. Maybe you haven't > > set the scale yet. > > > > This is an excerpt of my schema.xml file: > > > > <column name="moncotiza" > > required="true" > > scale="2" > > size="7" > > type="DECIMAL" /> > > > > What I usually do is to define the schema.xml file and from it > > obtain the .sql file via ant to create the database. > > > > Good luck, > > Álvaro. > > > > Jon August <[EMAIL PROTECTED]> wrote: Hey, > > > > I'm using decimal (in the schema) to store a dollar amount > in my MySQL > > database. I get the value from a web page and convert it to a > > BigDecimal before storing it. For some reason, the decimal portion > > gets truncated and $10.32 gets stored as 10. Should I be using > > something other than BigDecimal or is there something else wrong? > > > > Sorry if this is not a torque question. > > > > -Jon > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------- > > Want to start your own business? Learn how on Yahoo! Small Business. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]